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

140 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
conducer1312737(None) 
conduce12139231conduce_
conduced14136961conduced
conducers14136561conducers
conduces13129781conduces
condoler113412122condoler
condoner112913412condoner
conduct121411592conduc_t
conducted1547312conducted
conductor1447212conductor
conducts13118712conducts
confuter1338512confuter
conjurer17117682conjurer
conquer1838622conqu_er
consumer1238502consumer
inducer10318762_inducer
adducer1184163_adducer
bonder95324783bond__er
bonduc1136603bonduc__
bonducs1235553bonduc_s
caducei1243873c_aducei
cancer104220923can__cer
candider1237343candider
candler103516593cand_ler
censurer10228133censurer
cinder94119123cind__er
codder104416343co_d_der
coddler113710833co_ddler
coder86134223co_d__er
codger105814873co_d_ger
codices12512583co_dices
coendure1145463coendure_
coendured1344093coendured
coendures1245213coendures
coercer1138383co_ercer
coinsurer1144773coinsurer
colder95121853cold__er
colluder11276873colluder
colourer1037563colourer
communer14349303communer
commuter143010153commuter
computer144511513computer
conceder1338743conceder
concern113011963con__cern
concert113325223con__cert
conciser12310243conciser
concluder1444183concluder
concocter1247623concocter
concur10411103con__cur
condemner1445763condemner
condenser1287413condenser
condoes104319203cond_oes
condole102914953condole_
condoled123110723condoled
condolers122710573condolers
condoles113015803condoles
condone102616293condone_
condoned122612023condoned
condoners122811513condoners
condones112817393condones
condor94616973cond__or
condores113315643condores
conducing1537693conducing
conducive1745283conducive
conductors1546973conductors
conduit10713083condu_it
conduits111210063conduits
condylar1443653condylar
condyle13247053condyle_
condyles14277463condyles
confer114018683con__fer
confider1438123confider
confiner13311193confiner
confuse1238853confuse_
confused1437033confused
confuses13310363confuses
confute1239263confute_
confuted1437683confuted
confuters1437793confuters
confutes1339843confutes
congener112412203congener
conger95024273con__ger
conifer123212643con_ifer
conjure16109073conjure_
conjured18117903conjured
conjurers18126233conjurers
conjures17119913conjures
conjuror17144633conjuror
conker124721553con__ker
connecter1349053connecter
conner84423963con__ner
conniver1337493conniver
conquerer2044723conquerer
conquers1938223conqu_ers
consider11310393consider
consoler102812613consoler
consular1038813consular
consulter1198223consulter
consume11510133consume_
consumed1337923consumed
consumers1337203consumers
consumes12310413consumes
contuse9311413contuse_
contused1138443contused
contuses10413453contuses
convener132913163convener
conveyer16278143conveyer
convincer1645833convincer
convoker17226903convoker
coproducer1763073coproducer
corder94322883cord__er
coruler9311713co_ruler
costumer1275103costumer
coucher144515853co__ucher
couter84930223co__uter
endurer83210363_endurer
fonder104120063fond__er
fondler11348883fond_ler
fondue104510493fondu_e_
fondued12466363fondu_ed
fondues11399313fondu_es
honourer1146243honourer
induce93811533_induce_
induced11298933_induced
inducers11326953_inducers
induces103611813_induces
nondancer1245593nondancer
nonuser7299143non_user
ponder94521693pond__er
ponderer112410193ponderer
producer1355843producer
reducer1059003_reducer
rondure837313rondure_
rondures937713rondures
seducer1056503_seducer
sonder73623523sond__er
traducer1144583traducer
wonder103617813wond__er
wonderer12249183wonderer
yonder103214133yond__er

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.420425454.8
2DLD Change Limit1461621407.58019282.6
3Display Results1401400.0632222.2
 (SQL Overall)1786911408.06322161.9
 
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.