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

170 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
consoler10281261(None) 
condoler113412111condoler
console92715981console_
consoled112911441consoled
consolers112510921consolers
consoles103216151consoles
condole102914952condole_
condoled123110712condoled
condolers122710562condolers
condoles113015802condoles
condoner112913402condoner
consider11310392consider
consol82614112consol__
consols92914072consol_s
consular1038812consular
consulter1198222consulter
consumer1238502consumer
convoker17226902convoker
cooler84824712co__oler
nonsolar847072nonsolar
cajoler16398393c_ajoler
canaller1038953canaller
canceler12238913canceler
candler103516593can_dler
canoer85121073can_o_er
capsomer1445773capsomer
caroler93816753c_aroler
censer84516583cens__er
censor84011283censo__r
censored11197953censored
censurer10228133censurer
chiseler1335903chiseler
choler113717153c__holer
cineole91010003cineole_
cineoles10109403cineoles
coaler84121703co__aler
coaster94219033coas_ter
cobbler133311823co_bbler
coddler113710823co_ddler
coholder1436063co_holder
coiler84421593co__iler
coinsurer1144763coinsurer
colorer9312523co_lorer
commoner142710633commoner
compiler1438373compiler
composer145012953composer
concealer1368213concealer
conceder1338733conceder
conciser12310243conciser
concocter1247623concocter
condoes104319203condo_es
condolent1249833condolent
condone102616293condone_
condoned122612023condoned
condoners122811503condoners
condones112817393condones
condor94616963condo__r
condores113315633condores
conducer13127363conducer
condylar1443643condylar
condyle13247053condyle_
condyles14277463condyles
confer114018683con__fer
confider1438123confider
confiner13311193confiner
conformer1667463conformer
confuter1338503confuter
congealer1256703congealer
congener112412203congener
conger95024273con__ger
congoes103617303congo_es
conifer123212643con_ifer
conioses10313313conioses
conjoiner1855933conjoiner
conjurer17117673conjurer
conker124721553con__ker
conner84423963con__ner
conniver1337493conniver
connote9311613connote_
connoted1138863connoted
connotes10311453connotes
conquer1838613con_quer
consenter11312493consenter
conserver1448723conserver
considers1238933considers
consigner1246633consigner
consoling12310873consoling
consomme1445373consomme
consommes1545633consommes
consort91319903conso_rt
consorted1239773consorted
consorts101512333consorts
conspire1257873conspire
conspirer1355293conspirer
construer1146903construer
consul82312303consul__
consuls92412313consul_s
consult92513633consul_t
consulted1277923consulted
consulters1297203consulters
consultor1176463consultor
consults10219983consults
consume11510133consume_
consumed1337923consumed
consumers1337203consumers
consumes12310413consumes
contour939963conto_ur
controller1245523controller
convener132913163convener
conveyer16278143conveyer
convoke16207173convoke_
convoked18236163convoked
convokers18246103convokers
convokes17247703convokes
convolve1644653convolve
convolved1844083convolved
convolves1745323convolves
convoyed17225553convoyed
cooer74831013co__o_er
cooker124722453co__oker
cooled95224583co__oled
coolers93522493co__olers
cooper104221123co__oper
cooter85128613co__oter
coroner94218203co_roner
corselet10414573corselet
corslet9318063cors_let
coruler9311713co_ruler
cosher114819903co_s_her
cosier84423753co_s_ier
coster84331293co_s_ter
costlier1038523co_stlier
counseled1245053counseled
counselee1145593counselee
counselor1143543counselor
coupler114713013co_upler
crossover1484313crossover
fondler11348883fon_dler
gondolier1144723gondolier
honorer1039673hon_orer
hostler103411023ho_stler
insole63515863_insole_
insoles73516243_insoles
ionomer939833ion_omer
jostler14288223jo_stler
monomer11311893mon_omer
monster93214593mons_ter
noncolor1046513noncolor
nongolfer1343593nongolfer
nonpolar1046283nonpolar
nonskier1235983nonskier
nonsmoker1544303nonsmoker
nonsolid957403nonsolid
nonvoter1186893nonvoter
ostler63312193_o_stler
poisoner1046983poisoner
pooler83819843po__oler
posole8314223po_sole_
posoles9314883po_soles
ransomer1047883ransomer
reconsole1145693reconsole_
reconsoled1344553reconsoled
reconsoles1245143reconsoles
sonsier7711743sons_ier
tonsilar843953tonsilar
tooler63818613to__oler
unsober967633_unsober
unsolder937213_unsolder
winsomer1345773winsomer
wooler93615873wo__oler

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.1531167915.0
2DLD Change Limit1461621708.01618233.8
3Display Results1701700.0802125.0
 (SQL Overall)1786911708.24921662.1
 
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.