Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “chambered” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
chambered1914599(None) 
cambered15129001c_ambered
chamfered20165061chamfered
clambered16146131clambered
chaffered21154482chaffered
chamber164011062chamber__
chambers173410622chamber_s
chamferer19154692chamferer
chaptered17176792chaptered
chartered15158392chartered
chattered15197992chattered
clabbered16184762clabbered
clamberer15185272clamberer
cumbered15157962c_umbered
hammered16218852_hammered
hampered16239932_hampered
barbered13259543_barbered
blabbered13184593blabbered
camber124418483c_amber__
cambers134017443c_amber_s
cameoed1238383c_am_eoed
cancered132411553c_ancered
cankered153010223c_ankered
cantered113415983c_antered
capered123014043c_a_pered
careered1139493c_areered
catered103117773c_a_tered
chafferer20133923chafferer
chaired134211243cha__ired
chambering20116043chambering
chambermaid236963chambermaid
chambray2043143chamb_ray
chamfer17399863chamfer__
chamferers20153953chamferers
chamfers18409223chamfer_s
chammied18215973cham_mied
chamoised17335323chamoised
champed174111483cham__ped
champer163813413champer__
champers173311623champer_s
champerty2142883champerty
channeled1544913channeled
chapleted1743973chapleted
chared125423693cha___red
charred134614483cha__rred
charterer14197323charterer
chastened1545883chastened
chatterer14196843chatterer
checkered2144683checkered
cheered133713293ch__eered
chequered2442613chequered
chimere144010633chim_ere_
chimeres153511313chim_eres
chippered1945003chippered
chittered15166413chittered
choppered1964883choppered
chowdered1944013chowdered
chuntered1536663chuntered
clamber133311743clamber__
clamberers16174113clamberers
clambers144211293clamber_s
clamored1336953clam_ored
clamoured1444083clamoured
clattered12178413clattered
clavered14187633cla_vered
clobbered16164103clobbered
compered153414923c_ompered
cratered1149683cra_tered
cumberer14266993c_umberer
flambeed16324383flambe_ed
halberd1336053_halber_d
haltered123112563_haltered
hamboned1637003_hamboned
hammerer15278143_hammerer
hamperer15379093_hamperer
hankered16289443_hankered
harbored1438633_harbored
havered144011453_ha_vered
homebred16215893_homebred
homered133212713_hom_ered
jabbered2034433_jabbered
limbered13158123_limbered
lumbered13188233_lumbered
mammered12237653_mammered
membered1535903_membered
numbered13147143_numbered
pampered15229233_pampered
rehammered1843083rehammered
sabered103213023_sa_bered
scampered1635233scampered
schmeered1743273sch_meered
shambled16156153shamb_led
shattered13178203shattered
shimmered1744783shimmered
slabbered14165083slabbered
slumbered14215593slumbered
stammered1444643stammered
tabered103311593_ta_bered
tampered13279463_tampered
timbered13137383_timbered
umbered121510113__umbered
unhampered1853133unhampered
whimpered20144023whimpered
yabbered1633963_yabbered
yammered16225763_yammered

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit1486411056.59322545.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.