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

208 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
icicles113594(None) 
icicle1036581icicle_
icicled1234291icicled
bicycles1743882bicycles
chicles143512502chicles
circles1139902circles
cycles1339302_cycles
ibices10398162ibic_es
silicles1037072silicles
aciculas12228563aciculas
aisles64721143_aisles
amices105018013amic_es
apices104916263apic_es
articles10310243articles
auricles10138333auricles
bibles104617643_bibles
bices95029963_bic_es
bicycle1643993bicycle_
bicycled1843133bicycled
bicycler1742693bicycler
bicyclers1842233bicyclers
biles75542143_bi_les
binocles1236413binocles
biocycles1843523biocycles
birles84920643_birles
boucles113113003boucles
brickles162810283brickles
bricoles122610303bricoles
bridles104114473bridles
cables104527553_cables
caches137926913_caches
cackles153717203_cackles
calces104420053_calces
calicles123811433calicles
carles85435083_carles
caules85927253_caules
chicle134312543chicle_
chiles115425303_chiles
chyles144813283_chyles
cicalas1139303_cicalas
cicale10314503_cicale_
cicelies1269753_cicelies
cicely1338833_cicely
cilices113814023cilic_es
cimices13279803cimic_es
cinches144215773cinches
cines75239683_ci_nes
circle1039703circle_
circled1237583circled
circler1136423circler
circlers1235353circlers
circlet11311473circlet
circlets1235663circlets
cires74932913_ci_res
ciscoes113610733ciscoes
cites74435593_ci_tes
cities84524853_cities
citoles9312553citoles
civies114116443_civies
cliches144213743cliches
cobles104622883_cobles
cockles153414643_cockles
coles76055063_c_oles
cubicles1435883cubicles
cuticles1237893cuticles
cycle1239523_cycle_
cycled1436543_cycled
cycler1335913_cycler
cyclers1435873_cyclers
cyclos1338073_cyclos
deciles104417723deci_les
deices94119373deic_es
dices86434243_dic_es
dicyclies1744033dicyclies
disciples1446403disciples
edibles1048003edibles
ediles74016983edi_les
encircles1343923encircles
enisles72312603enisles
epicycles1843383epicycles
exciples1964773exciples
exiles134816403exi_les
failles102914133failles
fascicles1664263fascicles
fices106031163_fic_es
fiches145219533_fiches
ficoes114613463_ficoes
files85441273_fi_les
filles94224523_filles
foibles1238853foibles
funicles13246833funicles
grilles83715023grilles
guiles73919283gui_les
ibises83610543ibi_ses
icecaps1343863icecaps
iceless9219963ic_eless
ices66129643__ic_es
icier74313753ici__er
iciest82914743ici__est
icily101211693ici_l_y
iciness938863iciness
icings9428453ici_ngs
icones84616383ic_ones
ictuses938303ictuses
idiocies1145223idiocies
idles66720123__idles
imides94515343imi_des
imines84918353imi_nes
impales113311763impales
inches114419673i_nches
incises93414893inci_ses
incites93218483inci_tes
indices103513443indic_es
indoles83716363indoles
ingles74420873i_ngles
inhales10511863inhales
inkles103515653i_nkles
insoles73516243insoles
intitles8710003intitles
irides74519123iri_des
irises64221173iri_ses
isles54220563__isles
istles62814983i_stles
itches114916213i_tches
ivies84215763ivi__es
ixtles13217063i_xtles
juices1549423juic_es
liches114724293_liches
lisles63416283_lisles
macles107023223_macles
mailes84329113mai_les
micelles1288833micelles
miches134320733_miches
mickles153415003mic_kles
miles74645073_mi_les
milles84526563_milles
miracles1238333miracles
muscles11310563muscles
niches114419143_niches
nickles133713823nic_kles
nuncles939843nuncles
ocicats11137413ocicats
oracles93212423oracles
orioles7412993orioles
ossicles1054183ossicles
panicles121010113panicles
pedicles1338683pedicles
pickles153215443pic_kles
piles74742613_pi_les
pinocles1248693pinocles
prices104524543pric_es
prickles162511093prickles
quiches2139333quiches
radicles11249703radicles
recircles1344433recircles
recycles1535353recycles
reticles103912483reticles
rices75536153_ric_es
riches115022083_riches
ridicules1244263ridicules
rifles94217703_rifles
riles55343643_ri_les
rilles64725503_rilles
risibles1035783risibles
saices84221803saic_es
sanicles10149943sanicles
scales84529313sc_ales
scillas9310473scillas
seiches12513813seiches
sices75637273_sic_es
sickles133417543sic_kles
sidles74721153_sidles
silicle937753silicle_
similes92915233simi_les
slices84022853slic_es
smiles84522293smi_les
socles8418453_socles
spices104326033spic_es
spicules12219803spicules
spiles84227913spi_les
stickles142512103stickles
stifles103013393stifles
stiles64328773sti_les
swiples12339643swiples
tailles72516473tailles
tickles133416853tic_kles
tiles55542103_ti_les
titles63719923_titles
toiles63923513toi_les
trices84826333tric_es
trickles143013763trickles
tricycles1644363tricycles
trifles103814823trifles
triples94616873triples
tuilles72411923tuilles
tunicles10217133tunicles
uncles8317163_uncles
unicycles16143263unicycles
utricles1037223utricles
vehicles16204683vehicles
vesicles13127073vesicles
vices105725533_vic_es
voices114414013voic_es
voiles94616443voi_les
wavicles1633783wavicles
whiles124418013whi_les
wiches144418753_wiches
wiles85437873_wi_les

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.406440125.6
2DLD Change Limit1340272086.22021547.7
3Display Results2082080.0802600.0
 (SQL Overall)1786912086.70626646.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.