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

262 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
console9271598(None) 
condole102914951condole
consol82614111consol_
consoled112911451consoled
consoler102812611consoler
consoles103216151consoles
consols92914071consols
cineole91010002cineole
condoled123110722condoled
condoler113412122condoler
condoles113015802condoles
condone102616292condone
condyle13247052condyle
connote9311612connote
consolers112510922consolers
consomme1445372consomme
consort91319902consort
consul82312302consul_
consuls92412312consuls
consult92513632consult
consume11510132consume
convoke16207172convoke
convolve1644652convolve
insole63515862_insole
posole8314222po_sole
reconsole1145692reconsole
anisole71010833anisole
anole55330383_an_ole
benzole1837133benzole
cajole154011183c_ajole
camisole1246173camisole
candle94321483can_dle
cannoli937263cannoli
canoe75627253can_o_e
canola8313623can_ola
canoodle1144183canoodle
canso75019403canso__
cansos84915383canso_s
cantle84522153can_tle
canzone1858813canzone
capsule1137343capsule
cariole9818343cariole
castle84918963c_astle
cenacle1139123cenacle
cenote83715843cen_ote
cense75121403cens__e
censor84011293censo_r
censored11197953censored
censors93611843censors
censure92310603censure
centile94217183centile
cineol8108203cineol_
cineoles10109403cineoles
cineols9128853cineols
citole8311503c_itole
clodpole1343603clodpole
coalhole1345093coalhole
cobble123615263co_bble
coble94823173co__ble
cockle143913573co_ckle
codable12311663codable
coddle104713853co_ddle
codrove1336423codrove
coelome1139683coelome
coesite9713623coesite
coevolve1642963coevolve
coffle14359043co_ffle
coinable12311583coinable
coinsure1046933coinsure
cole66956113c___ole
colone85425003co_lone
commode1438123commode
commove1635963commove
comose105016843co_mose
compile13312443compile
compone136517193compone
compose135716663compose
compote135616463compote
concave1439373concave
concede12310103concede
conchae143911643conchae
conchie143312683conchie
concise11314473concise
concoct10312903concoct
concord12510343concord
condo85322593condo__
condoes104319203condoes
condolent1249833condolent
condolers122710573condolers
condom114215363condo_m
condoms124214083condoms
condoned122612023condoned
condoner112913413condoner
condones112817393condones
condor94616973condo_r
condores113315643condores
condors104018573condors
condos94322333condo_s
conduce12139233conduce
condyles14277463condyles
cone67256963con___e
conenose1078593conenose
confide13310203confide
confine12315583confine
conform14310463conform
confuse1238853confuse
confute1239263confute
conge85227593con__ge
congee96024473con_gee
conglobe1344153conglobe
congo85623133congo__
congoes103617303congoes
congos94219883congo_s
congou94313243congo_u
congous103615083congous
coniine9316803coniine
conine84528553con_ine
conioses10313313conioses
conjoin1638203conjoin
conjure16109073conjure
connate9315753connate
connive1238993connive
connoted1138863connoted
connotes10311453connotes
conoid9818883con_oid
cons66057693cons___
consent93723113consent
conserve1339923conserve
consider11310393consider
consign1038773consign
consist9316033consist
consoling12310873consoling
consommes1545633consommes
consorted1239773consorted
consorts101512343consorts
conspire1257873conspire
constable13311003constable
construe1049053construe
consular1038813consular
consulate11612233consulate
consulted1277923consulted
consulter1198223consulter
consults10219983consults
consumed1337923consumed
consumer1238503consumer
consumes12310413consumes
conte76633203con__te
conto76027173conto__
contort91422343contort
contos84923233conto_s
contour939973contour
control9310693control_
controls10311393controls
contuse9311413contuse
convene123314323convene
convoked18236163convoked
convoker17226903convoker
convokes17247703convokes
convolute1444943convolute
convolved1844083convolved
convolves1745323convolves
convoy14348543convo_y
convoyed17225553convoyed
convoys15267023convoys
convulse1345443convulse
cooee74531023co__oee
cool66940493co__ol_
cooled95224593co__oled
cooler84824713co__oler
coolie83821603co__olie
cools75632633co__ols
cooly105525423co__oly
copse95623923cops__e
coracle112011723coracle
cornicle1258783cornicle
cornpone1246933cornpone
corrode101310573corrode
corsage1039803corsage
corse75036183cors__e
corselet10414573corselet
corslet9318063cors_let
cosie74728263co_s_ie
cosily113613853co_sily
cosine83823513co_sine
costae85319683co_stae
costly114012333co_stly
counsel948543counsel_
counseled1245053counseled
counselee1145593counselee
counsels1037573counsels
couple104415963co_uple
cowpoke1835103cowpoke
cowrote12289673cowrote
coyote11411783co_yote
creole8913733c_reole
cresol8310213cresol_
cresols939653cresols
dongle83612493don_gle
dongola945473dongola
donsie7613643dons_ie
ensile62616473_ensile
fondle104412943fon_dle
foveole13106873foveole
foxhole2045073foxhole
gondola946663gondola
hondle103914523hon_dle
indole74516053_indole
insoles73516243_insoles
ionone6313443ion_one
jostle13319863jo_stle
lonesome1047473lonesome
longsome1145933longsome
manhole12311343manhole
midsole1037813midsole
mongoe94214983mongo_e
mongol94912533mongol_
mongols103310823mongols
monocle1139663monocle
monopole1249283monopole
monosome1299403monosome
monsoon938493monsoon
noisome947973noisome
noncola948293noncola
noncore9411953noncore
nonhome1248833nonhome
nonnoble1055343nonnoble
nonself1078513nonself
nonsolar847083nonsolar
nonsolid957413nonsolid
nonstyle1145003nonstyle
nonuple946153nonuple
obole75917143_o_bole
onshore10310013_onshore
onside7511803_onside
oriole6814293_oriole
osmole8128513_osmole
outsole71013433outsole
pensile92713543pensile
pinhole122010433pinhole
pinole83218783pin_ole
podsol946853podsol_
podsols1056513podsols
posoles9314883po_soles
pothole12312173pothole
pozole1758913po_zole
reconsoled1344553reconsoled
reconsoles1245143reconsoles
resole64624183_resole
rissole739783rissole
sole46053673___sole
sonsie6614863sons_ie
tensile72612733tensile
toluole736113toluole
tonsil6311873tonsil_
tonsils7310183tonsils
tonsure758783tonsure
tousle64514653tous_le
turnsole844693turnsole
unsold71410513_unsold
winsome1237463winsome
woesome1246733woesome
zonule1577483zon_ule

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272626.03322215.6
3Display Results2622620.0932817.2
 (SQL Overall)1786912626.51627423.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.