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 “consenter” 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.

128 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
consenter1131249(None) 
concenter13312211concenter
consented12311941consented
consenters12410841consenters
commenter151410692commenter
concenters14410592concenters
condenser1287412condenser
congener112412202congen_er
connecter1349052connecter
consent93723112consent__
consents102715892consent_s
conserver1448722conserver
consulter1198222consulter
contender1239562contender
contented12313042contented
contester11311192contester
convener132913162conven_er
convented15410752convented
converter14311012converter
absenter1086773_absenter
assenter867713_assenter
bonesetter1253183bonesetter
carpenter1346513carpenter
cementer1239193c_ementer
center84421413c___enter
coaster94219043coas__ter
coelentera1243643coelentera
cointer93616723co__inter
coinvented1643993coinvented
coinventor1562973coinventor
commencer17147803commencer
commender16167923commender
commented16129613commented
commenters16139483commenters
concealer1368223concealer
conceder1338743conce_der
conceited14310423conceited
conceiver1657413conceiver
concent114422513concent__
concentered1645013concentered
concents122516603concent_s
concerted14312113concerted
concocter1247633concocter
condemner1445763condemner
condense1179613condense_
condensed1387113condensed
condensers1386373condensers
condenses12710133condenses
condoner112913413condon_er
confected1739073confected
conferrer1447063conferrer
confiner13311193confin_er
confronter1544363confronter
confuter1338513con_futer
congealer1256703congealer
congeners122511133congen_ers
congested1338673congested
connected1438753connected
connecters1448023connecters
connector1347923connector
conner84423963con__n_er
consensus1144923consensus
consenting13313223consenting
conserve1339933conserve_
conserved1538853conserved
conservers1547683conservers
conserves14311193conserves
consider11310393cons_ider
consigner1246633consigner
consisted1238513consisted
consoler102812613cons_oler
consorted1239773consorted
conspirer1355293conspirer
construer1146913construer
consulted1277923consulted
consulters1297213consulters
consultor1176473consultor
consumer1238503cons_umer
contemner1347183contemner
contended1339273contended
contenders1348623contenders
content94326153content__
contents104018213content_s
contested12310703contested
contesters12410193contesters
continuer1148713continuer
convected1738783convected
convector1648083convector
convene123314323conven_e_
convened143412223conven_ed
conveners142911443conven_ers
convenes132916913conven_es
convenor13307613conven_or
convent123919413convent__
convents132614603convent_s
converser1438093converser
converted15311563converted
converters1539633converters
convertor1448783convertor
conveyer16278143conve_yer
convincer1645833convincer
correcter1348113correcter
corseted11311473corse_ted
cosseted1178343cosse_ted
coster84331293co_s__ter
counter94220153co__unter
coveter122912063co_ve_ter
cozener18328953co_zen_er
dissenter1059133dissenter
fomenter1339263fo_menter
honester1139713hon_ester
incenter102212093_incenter
indenter92311443_indenter
inserter82312133_inserter
insetter8218593_insetter
inventer112410843_inventer
loosener845633loosen_er
misenter10310833_misenter
monoester1146453monoester
monster93214603mons__ter
nonhunter1245053nonhunter
nonsense847393nonsense_
nonsenses948343nonsenses
nonskater1345143nonskater
orienter838313_orienter
pinsetter1145013pinsetter
presenter11311643presenter
tormenter1146703tormenter

Search took 9 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.436409841.7
2DLD Change Limit1486411287.64019455.6
3Display Results1281280.0632031.7
 (SQL Overall)1786911288.13921954.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.