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 “chamfered” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
chamfered2016506(None) 
chaffered21154481chaffered
chambered19145991chambered
chamferer19154691chamferer
cambered15129002c_ambered
chafferer20133922chafferer
chamfer17399862chamfer__
chamferers20153952chamferers
chamfers18409222chamfer_s
chaptered17176792chaptered
chartered15158392chartered
chattered15197992chattered
clambered16146132clambered
hammered16218852_hammered
hampered16239932_hampered
cameoed1238383c_am_eoed
cancered132411553c_ancered
cankered153010223c_ankered
cantered113415983c_antered
capered123014043c_a_pered
careered1139493c_areered
catered103117773c_a_tered
chafed154813913cha_f__ed
chafer144714573cha_fer__
chafers154512743cha_fer_s
chaffed19387703cha_f_fed
chaffer18389473chaffer__
chafferers21153173chafferers
chaffers19378003chaffer_s
chaired134211243cha__ired
chamber164011063chamber__
chambers173410623chamber_s
chamfering21125333chamfering
chamfron1844493chamf_ron
chammied18215973cham_mied
chamoised17335323chamoised
champed174111483cham__ped
champer163813413champer__
champers173311623champer_s
champerty2142883champerty
channeled1544913channeled
chapleted1743973chapleted
chared125423693cha___red
charred134614483cha__rred
charterer14197323charterer
chastened1545883chastened
chatterer14196843chatterer
chaufer15347943chaufer__
chaufers16347303chaufer_s
chauffeured235883chauffeured
checkered2144683checkered
cheered133713293ch__eered
chequered2442613chequered
chimere144010633chim_ere_
chimeres153511313chim_eres
chippered1945003chippered
chittered15166413chittered
choppered1964883choppered
chowdered1944013chowdered
chuntered1536663chuntered
clabbered16184763clabbered
clamberer15185273clamberer
clamored1336953clam_ored
clamoured1444083clamoured
clattered12178413clattered
clavered14187633cla_vered
coffered1737673c_offered
compered153414923c_ompered
cratered1149683cra_tered
cumbered15157963c_umbered
haltered123112563_haltered
hammerer15278143_hammerer
hamperer15379093_hamperer
hankered16289443_hankered
havered144011453_ha_vered
homered133212713_hom_ered
mammered12237653_mammered
pampered15229233_pampered
rehammered1843083rehammered
scampered1635233scampered
schmeered1743273sch_meered
shattered13178203shattered
shimmered1744783shimmered
stammered1444643stammered
tampered13279463_tampered
unhampered1853133unhampered
wafered14288433_wa_fered
whimpered20144023whimpered
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.453394461.4
2DLD Change Limit148641896.56322648.3
3Display Results89890.0332697.0
 (SQL Overall)178691897.04925349.8
 
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.