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

103 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
contender123956(None) 
contended1339271contended
contenders1348621contenders
commender16167922commender
conceder1338742conce_der
concenter13312212concenter
condenser1287412condenser
congener112412202congen_er
consenter11312492consenter
contemner1347182contemner
contend103511892contend__
contends112810572contend_s
contented12313042contented
contester11311182contester
continuer1148712continuer
convener132913162conven_er
intender93310442_intender
attender935913_attender
bartender1244603bartender
calender1138273c_alender
centner946853cent_n_er
coattended1443103coattended
coextended2142533coextended
cofounder1543823cofounder
colander1139033co_lander
coleader1139183co_leader
commander16127403commander
commencer17147803commencer
commended17137013commended
commenders17137143commenders
commenter151410693commenter
concealer1368223concealer
concede12310103conce_de_
conceded1438293conce_ded
conceders1437953conce_ders
concedes13311063conce_des
conceiver1657413conceiver
concenters14410583concenters
concluder1444183concluder
condemner1445763condemner
condense1179613condense_
condensed1387113condensed
condensers1386373condensers
condenses12710133condenses
condoner112913413condon_er
conferrer1447063conferrer
confider1438123con_fider
confiner13311193confin_er
confounder1643493confounder
congealer1256703congealer
congeners122511133congen_ers
connecter1349053connecter
conner84423963con__n_er
consented12311943consented
consenters12410843consenters
conserver1448723conserver
consider11310393con_sider
container11311073container
contemned1446793contemned
contemners1447073contemners
contemnor1344643contemnor
contending1449123contending
content94326153conten__t
contents104018213conten_ts
contested12310693contested
contesters12410183contesters
continue10311123continue_
continued1248483continued
continuers1247943continuers
continues11310993continues
contriver1448343contriver
convene123314323conven_e_
convened143412223conven_ed
conveners142911443conven_ers
convenes132916913conven_es
convenor13307613conven_or
convented15410753convented
converser1438093converser
converter14311013converter
conveyer16278143conve_yer
convincer1645833convincer
coriander1245663coriander
cozener18328953co_zen_er
cullender1243553cullender
distender11167743distender
engender1046633_engender
extender16146333_extender
goaltender1252003goaltender
intended102310413_intended
intenders10219373_intenders
intenser8199443_intenser
nonattender1251613nonattender
nonreader1045913nonreader
offender1543723_offender
oftener1035923_often_er
pontonier1146383pontonier
portended1345643portended
pretender1246663pretender
rottener8216973rotten_er
sentencer1156383sentencer
softener1145613soften_er
tender74121843___tender
untended102611153_untended

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.406440125.6
2DLD Change Limit1486411037.64019455.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.09222082.4
 
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.