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

211 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
icicle103658(None) 
icicled1234291icicled
icicles1135941icicles
bicycle1643992bicycle
chicle134312542chicle
cicale10314502_cicale
circle1039702circle
cycle1239522_cycle
icily101211692ici_ly
silicle937752silicle
acicula11228133acicula
aciculae12267703aciculae
acidly125211793acidly
agile65122263agi_le
aisle55223193_aisle
alible8311973alible
amice96122873amic_e
anile54634463ani_le
article9310923article
auricle9139813auricle
axile126020513axi_le
bible95119423_bible
bice86235563_bic_e
bicycled1843133bicycled
bicycler1742693bicycler
bicycles1743883bicycles
bile66147183_bi_le
binocle1136493binocle
biocycle1743143biocycle
birle75023633_birle
boucle103712783boucle
brickle15279933brickle
bricole112810493bricole
bridle94115463bridle
cable95329913_cable
cache125122483_cache
cackle143416923_cackle
calicle113111433calicle
carle74535703_carle
chicles143512503chicles
chicly16429203chicly
chile105626893_chile
chyle134913483_chyle
cicala10310053_cicala
cicely1338833_cicely
cilice103213353cilic_e
cine66242943_ci_ne
circled1237583circled
circler1136423circler
circles1139903circles
circlet11311473circlet
cire65836373_ci_re
cite65640343_ci_te
citole8311503citole
civie103716353_civie
cliche133712453cliche
coble94823173_coble
cockle143913573_cockle
cole66956113_c_ole
cubicle1337003cubicle
cuticle1138233cuticle
cycled1436543_cycled
cycler1335913_cycler
cycles1339303_cycles
cyclo1237703_cyclo
decile94619213deci_le
deice84320033deic_e
dice75841893_dic_e
dicycly1843273dicycly
disciple1346673disciple
docile94213123doci_le
edible969353edible
edile64819493edi_le
encircle1243943encircle
enisle63412093enisle
epicycle1743393epicycle
exciple1874683exciple
exile126117653exi_le
facile112514883faci_le
faille93414743faille
fascicle1554633fascicle
fice95737113_fic_e
fiche134616743_fiche
fickle153912973fic_kle
fictile1238023fictile
file75446643_fi_le
fille84327403_fille
foible11410383foible
funicle12237483funicle
grille74315743grille
guile64521133gui_le
ibices10398163ibices
ice56737243__ic_e
icecap1245223icecap
icier74313753ici_er
iciest82914743iciest
icing86017753ici_ng
icings9428453icings
ickily1535753ickily
ictic9311803ictic__
idle55423763__idle
ilial55317843ilial_
imide85716893imi_de
imine75821063imi_ne
impale102811663impale
incise83515333inci_se
incite83618733inci_te
indole74516053indole
ingle64120433i_ngle
inhale9411513inhale
inkle94515833i_nkle
insole63515863insole
intitle7610583intitle
isle45121703__isle
istle52214713i_stle
ixtle12168013i_xtle
juice14311323juic_e
lice66045063_lic_e
licitly12276673licitly
lisle53916723_lisle
macle96127003_macle
maile75232223mai_le
meikle1236653meikle
mice87442233_mic_e
micelle1178343micelle
miche126219243_miche
mickle143715133mic_kle
mile66352573_mi_le
mille75029133_mille
miracle1138843miracle
miscible1447673miscible
mixible18195093mixible
muscle10310973muscle
nice65534713_nic_e
niche105016793_niche
nickle123814483nic_kle
nuncle839363nuncle
ocicat101412813ocicat
oracle84313293oracle
oriole6814293oriole
ossicle944483ossicle
panicle11129983panicle
pedicle1238973pedicle
pice84641093_pic_e
pickle144215653pic_kle
pile65649693_pi_le
pinocle1138143pinocle
plicae10410953plicae
price93725413pric_e
prickle153611013prickle
quiche2057903quiche
radicle103510713radicle
recircle1244433recircle
recycle1445343recycle
reticle94112623reticle
rice64942913_ric_e
ridicule1144393ridicule
rifle85518333_rifle
rile45650533_ri_le
rille55728733_rille
risible937923risible
saice75424053saic_e
sanicle91210263sanicle
scale74629143sc_ale
scilla8310943scilla
seiche11811833seiche
sice65545593_sic_e
sickle124418323sic_kle
sidle65124033_sidle
silicles1037073silicles
simile83115633simi_le
slice74925823slic_e
smile74823923smi_le
socle7419573_socle
spicae104313703spicae
spice95528813spic_e
spicule11269933spicule
spile75230083spi_le
stickle132410973stickle
stifle93611903stifle
stile54931573sti_le
swiple11379233swiple
taille63116923taille
tickle124616743tic_kle
tile45451443_ti_le
title54721073_title
toile54626493toi_le
trice75127493tric_e
trickle133613443trickle
tricycle1543893tricycle
trifle94012883trifle
triple84215923triple
tuille63012643tuille
tunicle9308033tunicle
twice104711123twic_e
uncle7317053_uncle
unicycle15153183unicycle
utile54718933uti_le
utricle937913utricle
vehicle15175253vehicle
vesicle12217923vesicle
vice95732853_vic_e
vile76139803_vi_le
vincible1544753vincible
virile9313433viri_le
visible1236923visible
voice104915323voic_e
voile84719723voi_le
wavicle1534063wavicle
while115418693whi_le
wile75944373_wi_le

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162115.78319490.9
3Display Results2112110.0603516.7
 (SQL Overall)1786912116.23328668.5
 
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.