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

194 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
consoled11291145(None) 
condoled123110721condoled
console92715981console_
consoler102812611consoler
consoles103216151consoles
censored11197952censored
condole102914952condole_
condoler113412122condoler
condoles113015802condoles
condoned122612022condoned
connoted1138862connoted
consol82614112consol__
consolers112510922consolers
consols92914072consol_s
consorted1239772consorted
consulted1277922consulted
consumed1337922consumed
convoked18236162convoked
convolved1844082convolved
convoyed17225552convoyed
cooled95224592co__oled
counseled1245052counseled
nonsolid957412nonsolid
reconsoled1344552reconsoled
bobsled12297153bobs_led
bosomed1238003bo_somed
cajoled17428283c_ajoled
canaled103615563can_aled
canalled1139583canalled
canceled13279403canceled
candled113815743can_dled
cannoned11118143cannoned
canoed94618963can_o_ed
canoodled1342803canoodled
cantoned111411523cantoned
capsuled1334533capsuled
caroled103717693c_aroled
castled104311513c_astled
censed94016323cens__ed
censured11248913censured
censused11184973censused
chiseled1435883chiseled
cineole91010003cineole_
cineoles10109403cineoles
coaled95022713co__aled
coasted104015953coas_ted
cobbled143411633co_bbled
cockled163710823co_ckled
cocooned1337293cocooned
coddled123410573co_ddled
coevolved1842453coevolved
coffled16297363co_ffled
cohosted1436133cohosted
coiled95123943co__iled
coinsured1245513coinsured
coled85540763c___oled
colored10313473co_lored
commoved1844763commoved
compiled1537813compiled
composed154612063composed
concaved1636223concaved
concealed1458133concealed
conceded1438293conceded
concocted1346763concocted
concord12510343conco_rd
condoes104319203condo_es
condolent1249833condolent
condolers122710573condolers
condone102616293condone_
condoner112913413condoner
condones112817393condones
condores113315643condores
conduced14136963conduced
condyle13247053condyle_
condyles14277463condyles
coned86040053con___ed
confided1537453confided
confined14310403confined
conformed1767463conformed
confound1445903confound
confused1437033confused
confuted1437683confuted
congaed11399743con_gaed
congealed1346593congealed
congeed113212313con_geed
conglobed1543293conglobed
congoes103617303congo_es
conioses10313313conioses
conjoined1965463conjoined
conjured18117903conjured
conked135019113con__ked
conned95119703con__ned
connived1436433connived
connote9311613connote_
connotes10311453connotes
conoid9818883con_o_id
consented12311943consented
conserved1538853conserved
consider11310393consider
consigned1346323consigned
consisted1238503consisted
consoling12310873consoling
consomme1445373consomme
consommes1545633consommes
consort91319903conso_rt
consorts101512343consorts
conspired1445663conspired
construed1247313construed
consul82312303consul__
consular1038813consular
consuls92412313consul_s
consult92513633consul_t
consulter1198223consulter
consults10219983consults
consume11510133consume_
consumer1238503consumer
consumes12310413consumes
contorted1239473contorted
contoured1237303contoured
controlled1345383controlled
contused1138443contused
convened143412223convened
conveyed17247923conveyed
convoke16207173convoke_
convoker17226903convoker
convokes17247703convokes
convoluted1643703convoluted
convolve1644653convolve
convolves1745323convolves
convulsed1544383convulsed
cooed84534343co__o_ed
cooeed95917863co__oeed
cooked135921363co__oked
cooler84824713co__oler
cooped114821603co__oped
corbeled1338373corbeled
cordoned12229613cordoned
cornrowed1543623cornrowed
corroded12147513corroded
corselet10414573corselet
corseted11311473corseted
corslet9318063cors_let
coshed124217543co_s_hed
cosied94819883co_s_ied
cosseted1178343cosseted
costed95623113co_s_ted
cottoned1138033cottoned
counselee1145593counselee
counselled1344533counselled
coupled124312673co_upled
cowboyed1943373cowboyed
cowled125218393co__wled
cowshed1637773cows_hed
dogsled1035193dogs_led
ensiled82611433_ensiled
ensouled935833_ensouled
fondled12399423fon_dled
fooled104317823fo__oled
hanseled1237713hanseled
hondled123510653hon_dled
honored11310123hon_ored
houseled1237283houseled
insole63515863_insole_
insoles73516243_insoles
insouled936113_insouled
jostled15267083jo_stled
monocled1337113monocled
morseled1147193morseled
nonsked1236233nons_ked
nonsolar847083nonsolar
nonsolids1045383nonsolids
poisoned1136953poisoned
pooled94619813po__oled
posole8314223po_sole_
posoles9314883po_soles
potholed1448393potholed
ransomed1146933ransomed
reconsole1145693reconsole_
reconsoles1245143reconsoles
resoled84119283_resoled
snooled84513943_snooled
soled65835173___soled
sponsored1243223sponsored
tinseled935763tinseled
tonsured976383tonsured
tooled74918903to__oled
topsoiled1242643topsoiled
tousled84710363tous_led
unsoiled92412083_unsoiled
unsold71410513_unsol_d
unsolid8138373_unsolid
unsolved1237833_unsolved
unsowed112511053_unsowed
wooled103715503wo__oled

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621946.72021750.3
3Display Results1941940.0762552.6
 (SQL Overall)1786911947.23224708.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.