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

116 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
contester1131119(None) 
contested12310701contested
contesters12410191contesters
concenter13312212concenter
congested1338672congested
connecter1349052connecter
consenter11312492consenter
contemner1347182contemner
contender1239562contender
contented12313042contented
contest93523232contest__
contests103413382contest_s
converter14311012converter
honester1139712hon_ester
monoester1146452monoester
anteater8311603_anteater
attester836503_attester
canister101710853can_ister
cannister1155723cannister
centeses1079443centes_es
coaster94219043co__aster
coattested1342993coattested
coinvestor1562573coinvestor
commenter151410693commenter
composter15369573composter
concealer1368223concealer
conceder1338743conce_der
conceited14310423conceited
conceiver1657413conceiver
concenters14410593concenters
concerted14312113concerted
conciser12310243concis_er
concocter1247633concocter
condemner1445763condemner
condenser1287413condenser
confected1739073confected
conferrer1447063conferrer
confessed1546053confessed
confesses1438623confesses
confessor1444343confessor
confuter1338513con_futer
congealer1256703congealer
congener112412203conge_ner
congest104618773congest__
congests113510383congest_s
connected1438753connected
connecters1448023connecters
connector1347923connector
consented12311943consented
consenters12410843consenters
conserver1448723conserver
consisted1238513consisted
consulter1198223consulter
contacted14139103contacted
contactee13149313contactee
contactor1348433contactor
container11311073container
contemned1446793contemned
contemners1447073contemners
contemnor1344643contemnor
contended1339273contended
contenders1348623contenders
content94326153content__
contents104018213content_s
contes84432913contes___
contessa1044583contes_sa
contessas1145023contessas
contestant1269933contestant
contesting13312213contesting
context163913433context__
contexts17378653context_s
contexture1943933contexture
continuer1148713continuer
contorted1239483contorted
contrasted1348583contrasted
contrite10318543contrite_
contriver1448343contriver
contuse9311413contus_e_
contused1138443contus_ed
contuses10413453contus_es
convected1738783convected
convector1648083convector
convener132913163conve_ner
convented15410753convented
converser1438093converser
converted15311563converted
converters1539633converters
convertor1448783convertor
conveyer16278143conve_yer
correcter1348113correcter
coster84331293co___ster
cotter84926673co_t__ter
counterstep1547113counterstep
countesses1248843countesses
coveter122912063co_ve_ter
cutesier1045623c_utesier
cytaster1383863c_ytaster
detester9239683_detester
dopester1137253do_pester
forester11313673fo_rester
infester11239433_infester
jokester1934443jo_kester
modester1197483mo_dester
molester1099373mo_lester
monoesters1245993monoesters
monster93214603mon__ster
nester64124183__n_ester
nonvested1346003nonvested
obtested1135453_obtested
poetaster1145673poetaster
polyester1445353polyester
protester111510483protester
songster935793son_gster
tester64227153___tester
uncontested1444563uncontested
untested92612423_untested

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.420425454.8
2DLD Change Limit1486411166.97021325.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.43624030.5
 
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.