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

139 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
condemns133629(None) 
condemn1237111condemn_
contemns1237401contemns
codeins103715482co_deins
codens94821012co_de_ns
concerns122710832concerns
condemned1545102condemned
condemner1445762condemner
condemners1546022condemners
condemnor1443592condemnor
condemnors1543952condemnors
condense1179612conde_nse
condoms124214082condom_s
contemn1137802contemn_
bonders104120663bonde_rs
bondmen1237893bondmen_
candelas1139533candelas
candent10417363cande_nt
canteens1038573canteens
cinders104617753cinde_rs
cinemas1138023cin_emas
codders114114443codde_rs
codecs115112933co_de_cs
codeias103911213co_deias
codein94916713co_dein_
codeina104010323co_deina
codeinas11338013co_deinas
codeine103815033co_deine
codeines113114523co_deines
coden86128543co_de_n_
coders95426973co_de_rs
codes86247293co_de__s
codlins104116243co_dlins
codons96119463co_d_ons
cognomens1443863cognomens
colleens1036843colleens
columns1136473co_lumns
conceals123111013conceals
concedes13311053concedes
conceits122813613conceits
concent114422513conce_nt
concents122516603concents
concepts143110303concepts
concern113011963concern_
concerts123016063concerts
condemning1665743condemning
condensed1387113conde_nsed
condenser1287413conde_nser
condenses12710133condenses
condign1147733condign_
condiment14410853condiment
condiments1548193condiments
condoes104319203cond_oes
condoles113015803condoles
condom114215363condom__
condone102616293cond_one
condones112817393condones
condores113315633condores
condors104018553cond_ors
condos94322333cond__os
conduces13129773conduces
conducts13118703conducts
conduits111210053conduits
condyles14277463condyles
cones76457423con_e__s
coneys115218423con_e_ys
confects153110873confects
confers124120093confe_rs
confess12399903confe_ss
congeals11309853congeals
congees103517923conge_es
congers104223233conge_rs
conges94928173conge__s
congests113510383congests
conies84338593conie__s
conins84327233con__ins
coniums11311863conium_s
conjoins1738133conjoins
conkers133721043conke_rs
connects123010563connects
conners94023113conne_rs
conns75024233con___ns
consent93723113conse_nt
consents102715893consents
consigns1137533consigns
consumes12310413consumes
contains10316533contains
contemned1446793contemned
contemner1347183contemner
contemners1447073contemners
contemnor1344643contemnor
contemnors1445243contemnors
contempo1444833contempo
contempt1447473contempt
contempts1545063contempts
contend103511893conte_nd
contends112810573contends
content94326153conte_nt
contents104018213contents
contes84432913conte__s
contests103413383contests
contexts17378653contexts
convects153410993convects
convene123314323conve_ne
convenes132916913convenes
convent123919413conve_nt
convents132614603convents
converts133213553converts
convexes20278273convexes
conveys15308223conve_ys
copens106119963co_pe_ns
corders104520873corde_rs
cordons104415763cord_ons
covens114919263co_ve_ns
cozens176314923co_ze_ns
cundums1235183cundum_s
goddamns1341983goddamns
hoddens12378803hodde_ns
hoidens11329083hoide_ns
hordeins1238323hordeins
hoydens14347403hoyde_ns
lindens839413linde_ns
lodens74315063lo_de_ns
loudens8368053loude_ns
modems114610763mo_dem_s
moderns1037963mo_derns
mondes94322353monde__s
nondemand1344753nondemand
nondemands1453593nondemands
odeons739023_o_deons
oedemas1056693_oedemas
ponders103618843ponde_rs
rondels82510053ronde_ls
soddens9348413sodde_ns
sonders83820713sonde_rs
sondes74922873sonde__s
tandems1037633tandem_s
tonemes9311683ton_emes
wonders113315993wonde_rs

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621398.37317456.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911398.60920756.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.