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

83 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
contenders134862(None) 
contender1239561contender_
commenders17137142commenders
conceders1437952conce_ders
concenters14410582concenters
condensers1386372condensers
congeners122511122congen_ers
consenters12410842consenters
contemners1447072contemners
contended1339272contende_d
contends112810572contend__s
contesters12410182contesters
continuers1247942continuers
conveners142911442conven_ers
intenders10219362_intenders
attenders1045273_attenders
bartenders1344223bartenders
calenders1237403c_alenders
centners1057243cent_n_ers
cofounders1643333cofounders
colanders1238013co_landers
coleaders1237803co_leaders
commanders17146683commanders
commencers18156373commencers
commender16167923commender_
commenters16139473commenters
concealers1476913concealers
conceder1338733conce_der_
concedes13311053conce_de_s
conceivers1746313conceivers
concenter13312213concenter_
concluders1543493concluders
condemners1546023condemners
condenser1287413condenser_
condenses12710133condense_s
condoners122811493condon_ers
conferrers1546453conferrers
confiders1537483con_fiders
confiners1439953confin_ers
confounders1742923confounders
congealers1365663congealers
congener112412193congen_er_
connecters1448013connecters
conners94023113con__n_ers
consenter11312493consenter_
conservers1547673conservers
considers1238933con_siders
containers1249903containers
contemner1347183contemner_
contemnors1445243contemnors
contend103511893contend___
contending1449123contending
contented12313043contente_d
contents104018213conten__ts
contester11311183contester_
continuer1148713continuer_
continues11310993continue_s
contrivers1547243contrivers
convener132913163conven_er_
convenes132916913conven_e_s
convenors14277633conven_ors
conversers1547353conversers
converters1539633converters
conveyers17267203conve_yers
convincers1745063convincers
corianders1344893corianders
cozeners19297783co_zen_ers
cullenders1343193cullenders
distenders12166733distenders
engenders1145293_engenders
extenders17125673_extenders
goaltenders1351803goaltenders
intendeds11265743_intendeds
intender93310433_intender_
nonattenders1351353nonattenders
nonreaders1145433nonreaders
offenders1643403_offenders
pontoniers1245313pontoniers
pretenders1345243pretenders
sentencers1274783sentencers
softeners1245133soften_ers
tenders83719723___tenders
wontedness1445503wontedness

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 Filter1786911406030.1701051123.5
2DLD Change Limit140603836.98620126.4
3Display Results83830.0461804.3
 (SQL Overall)178691837.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.