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

277 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
condole10291495(None) 
condoled123110721condoled
condoler113412121condoler
condoles113015801condoles
condone102616291condone
condyle13247051condyle
console92715981console
candle94321482cand_le
cineole91010002cineole
coddle104713852co_ddle
condo85322592condo__
condoes104319202condoes
condolent1249832condolent
condolers122710572condolers
condom114215362condo_m
condoms124214082condoms
condoned122612022condoned
condoner112913412condoner
condones112817392condones
condor94616972condo_r
condores113315642condores
condors104018572condors
condos94322332condo_s
conduce12139232conduce
condyles14277462condyles
connote9311612connote
consol82614112consol_
consoled112911452consoled
consoler102812612consoler
consoles103216152consoles
consols92914072consols
convoke16207172convoke
convolve1644652convolve
fondle104412942fond_le
gondola946662gondola
hondle103914522hond_le
indole74516052_indole
anole55330383_an_ole
bandore10611633bandore
benzole1837133benzole
bindle94516263bind_le
bondable13169273bondable
bondage1138253bondage
boodle93215033bood_le
bundle94315573bund_le
cajole154011183c_ajole
candela1089743candela
candled113815743cand_led
candler103516593cand_ler
candles104422343cand_les
candor94516423cando_r
candors104216763candors
candour104210243candour
cannoli937263cannoli
canoe75627253can_o_e
canola8313623can_ola
canoodle1144183canoodle
cantle84522153can_tle
canzone1858813canzone
cariole9818343cariole
caudle93912913caud_le
cenacle1139123cenacle
cenote83715843cen_ote
centile94217183centile
chondrule1542393chondrule
cineol8108203cineol_
cineoles10109403cineoles
cineols9128853cineols
citole8311503c_itole
cladode1134613cladode
clodpole1343603clodpole
coalhole1345093coalhole
cobble123615263co_bble
coble94823173co__ble
cockle143913573co_ckle
codable12311663codable
coddled123410573co_ddled
coddler113710833co_ddler
coddles114213593co_ddles
code77347733co_d__e
codon86522853co_do_n
codons96119463co_dons
codrove1336423codrove
coelome1139693coelome
coendure1145463coendure
coevolve1642963coevolve
coffle14359043co_ffle
coinable12311583coinable
coldly12459953cold_ly
cole66956113c___ole
colone85425003co_lone
commode1438123commode
commove1635963commove
comose105016853co_mose
compile13312443compile
compone136517193compone
compose135716663compose
compote135616463compote
concave1439373concave
concede12310103concede
conchae143911643conchae
conchie143312683conchie
concise11314473concise
concoct10312903concoct
concord12510343concord
condemn1237113condemn
condense1179613condense
condign1147733condign
condolence1565313condolence
condoling13510373condoling
condonable1545443condonable
condoners122811513condoners
conduced14136963conduced
conducer13127373conducer
conduces13129783conduces
conduct121411593conduct
conduit10713083conduit
condylar1443653condylar
cone67256963con___e
conenose1078593conenose
confide13310203confide
confine12315583confine
conform14310463conform
confuse1238853confuse
confute1239263confute
conge85227593con__ge
congee96024473con_gee
conglobe1344153conglobe
congo85623133congo__
congoes103617303congoes
congos94219883congo_s
congou94313243congo_u
congous103615083congous
coniine9316803coniine
conine84528553con_ine
conioses10313323conioses
conjoin1638203conjoin
conjure16109073conjure
connate9315753connate
connive1238993connive
connoted1138863connoted
connotes10311453connotes
conodont11411153conodont
conoid9818883con_oid
consolers112510923consolers
consomme1445373consomme
consort91319903consort
consul82312303consul_
consuls92412323consuls
consult92513633consult
consume11510133consume
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
coracle112011723coracle
cordage11310063cordage
cordate10315223cordate
cordelle1148433cordelle
cordite10315263cordite
cordoba1255743cordoba
cordon95017293cordo_n
cordoned12229613cordoned
cordons104415763cordons
cornicle1258783cornicle
cornpone1246933cornpone
corrode101310573corrode
coude85022633coud__e
couple104415963co_uple
cowpoke1835103cowpoke
cowrote12289673cowrote
coydog1335133coydo_g
coydogs1434493coydogs
coyote11411783co_yote
cradle93313163crad_le
creole8913733c_reole
cuddle104414533c_uddle
curdle95514313curd_le
dandle84218093dand_le
dindle84417223dind_le
dole56550003___dole
dongle83612493don_gle
dongola945473dongola
doodle83212853dood_le
fondled12399423fond_led
fondler11348883fond_ler
fondles113512613fond_les
fondly13299043fond_ly
fondue104510493fond_ue
fordone1149383fordone
foveole13106873foveole
foxhole2045073foxhole
frondose1244523frondose
gondolas1046193gondolas
gondolier1144723gondolier
handle104219293hand_le
hondled123510653hond_led
hondles113614523hond_les
indol63714873_indol_
indoles83716363_indoles
indols74714203_indols
insole63515863_insole
ionone6313443ion_one
kindle114414233kind_le
mandola1039023mandola
manhole12311343manhole
module93011033mo_dule
moidore1056153moidore
monde85723143mond__e
mondo85721233mondo__
mondos95217333mondo_s
mongoe94214983mongo_e
mongol94912533mongol_
mongols103310823mongols
monocle1139663monocle
monopole1249283monopole
noddle83211363no_ddle
nodose738883no_dose
nodule7309803no_dule
noncola948303noncola
noncore9411953noncore
nonhome1248833nonhome
nonnoble1055343nonnoble
nonuple946153nonuple
noodle73212543nood_le
obole75917143_o_bole
odyle9349593_o_dyle
oriole6814293_oriole
osmole8128513_osmole
pandore10411853pandore
pinhole122010433pinhole
pinole83218783pin_ole
poodle93112043pood_le
posole8314223po_sole
pothole12312173pothole
pozole1758913po_zole
reconsole1145693reconsole
rondel73212643rondel_
rondelet9410353rondelet
rondelle946813rondelle
rondels82510053rondels
rondo65218373rondo__
rondos74616733rondo_s
rondure837313rondure
rundle73214233rund_le
sonde64622833sond__e
toddle85811033to_ddle
toluole736113toluole
tondo69718683tondo__
tondos75115923tondo_s
undone7914253_undone
wandle105316663wand_le
windle104617953wind_le
yodle94515043yo_d_le
zonule1577483zon_ule

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272777.01619103.1
3Display Results2772770.0932978.5
 (SQL Overall)1786912777.52923733.7
 
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.