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

250 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
sanicle9121026(None) 
panicle11129981panicle
sanicles10149941sanicles
anile54634462_ani_le
calicle113111432calicle
canticle1239702canticle
funicle12237482funicle
manacle11310282manacle
manille92613272manille
maniple11249652maniple
panicled13106782panicled
panicles121010112panicles
radicle103510712radicle
saice75424052sa_ic_e
senile63420212seni_le
silicle937752silicle
tunicle9308032tunicle
wavicle1534062wavicle
agile65122263_agi_le
aisle55223193_a_isle
alible8311973_alible
amice96122873_amic_e
anele55628833_an_ele
angle64528873_an_gle
anil46437433_ani_l_
anils56326723_ani_ls
anime75423203_ani_me
anise55129703_ani_se
anisole71010833_anisole
ankle95220253_an_kle
anole55330383_an_ole
anticly12410053_anticly
article9310923article
auricle9139813auricle
axile126020513_axi_le
babiche1644573babiche
bangle94018953ban_gle
barnacle1245943barnacle
bernicle1245443bernicle
binocle1136493binocle
caliche14329963caliche
calicles123811433calicles
calycle14245833calycle
canaille1048413canaille
cancel105316683can_cel
candle94321483can_dle
canine83826703cani_ne
canticles1339183canticles
cantle84522153can_tle
cariole9818343cariole
caulicle1245043caulicle
cenacle1139123cenacle
chicle134312543_chicle
clavicle1543603clavicle
cornicle1258783cornicle
cubicle1337003cubicle
cuticle1138233cuticle
dance85223133dan_c_e
dandle84218093dan_dle
dangle84119303dan_gle
dariole8711163dariole
denticle1137773denticle
enisle63412093_enisle
facile112514883faci_le
faille93414743fa_ille
fancily1538253fancily
fascicle1554633fascicle
funicles13246833funicles
ganache1346223ganache
habile11515213habi_le
hance105424153han_c_e
handle104219293han_dle
hantle94318203han_tle
icicle1036583_icicle
jangle144416293jan_gle
kantele1138253kantele
labile8315223labi_le
lance75126723lan_c_e
macle96127003ma__cle
maile75232223ma_i_le
malice104818483malic_e
manacled1336453manacled
manacles1239523manacles
manche133515103man_che
manciple1445093manciple
mandible1337543mandible
mangle93921323man_gle
manhole12311343manhole
manic94629443manic__
manics103919933manic_s
manicure1245803manicure
manila84518303mani_la
manilla93012473manilla
manilles102312603manilles
maniples12269423maniples
mantle84420923man_tle
monocle1139663monocle
nance74721843nan_c_e
nice65534713__nic_e
niche105016793__niche
nickle123814483__nickle
nuncle839363nun_cle
ossicle944483ossicle
panache1458433panache
panic93923903panic__
panicked1785173panicked
panicky1833853panicky
panics103815363panic_s
panicum1346393panicum
panoche1456383panoche
pantile93918483pantile
particle1239533particle
pedicle1238973pedicle
penile82219603peni_le
pinocle1138143pinocle
radiale83813523radiale
radicel10278873radicel
radicles11249703radicles
rance75028513ran_c_e
rankle103414883ran_kle
reticle94112623reticle
sabine84020393sabi_ne
sable74732163sa__ble
saccule1136743saccule
saddle83915493sa_ddle
safrole1037253safrole
saices84221803sa_ices
sail45447163sa_i_l_
sailed74327763sa_i_led
sailer63526103sa_i_ler
sails55738103sa_i_ls
saintly1039343saintly
saithe94713913sa_ithe
salable91415463salable
sale44959703sa___le
salic73424713salic__
salicin9311223salicin
salicine10311703salicine
saline65132703sali_ne
samiel8313333samiel_
samiels939763samiels
samite83020603sami_te
sample104215013sa_mple
sancta839833san_cta
sandable111612823sandable
sandal73317283sandal_
sandaled1039243sandaled
sandals82715203sandals
sandfly1435643sandfly
sandpile1146773sandpile
sane45954343san___e
sanely93114613san_ely
sanidine939853sanidine
sanies63031953sani_es
saning75127643sani_ng
sanious7514103sanious
sanitate8612043sanitate
sanities81219773sanities
sanitise81511813sanitise
sanitize171410083sanitize
sanity9316203sani_ty
santol64515243santol_
santols73513323santols
satiable10310733satiable
satiate7315403satiate
satire63218003sati_re
sauce75121653sa_uc_e
saucily1237913saucily
savable121711863savable
savine94220283savi_ne
sayable121411613sayable
seance83716693sean_c_e
sedile73517233sedi_le
seiche11811833s_eiche
seniles72618023seni_les
sensible1037853sensible
seviche1545113seviche
shingle117711283shingle
sice65545593s__ic_e
sickle124418323s__ickle
sidle65124033s__idle
silicles1037073silicles
simile83115633simi_le
since75024173sin_c_e
single74520603sin_gle
sinicize1947333sinicize
slice74925823s_lic_e
sluice849513sluic_e
smile74823923s_mi_le
snaffle13216253snaffle
snail57020203snai_l_
snailed83811923snai_led
snails64816653snai_ls
snick114416013s_nic_k
snicked143811633s_nicked
snicker133012673s_nicker
snicks124312473s_nicks
snide64318723s_ni_de
sniffle13287653s_niffle
sniggle9316833s_niggle
sniglet83612413s_niglet
snipe75320573s_ni_pe
snivel9368853s_nivel
socle7419573s__ocle
sonic75225293sonic__
sonicate10310933sonicate
sonics84315633sonic_s
spadille1145193spadille
spancel1147363span_cel
spangle1038403span_gle
spaniel948923spaniel_
spaniels1045963spaniels
spansule1043623spansule
spicae104313703s_picae
spice95528813s_pic_e
spicule11269933s_picule
spile75230083s_pi_le
spindle103210093spindle
spinule9299993spinule
splice104915103splic_e
stabile9312063stabi_le
stance84316913stan_c_e
stanine73417073stani_ne
statice92614033static_e
stickle132410973s_tickle
stifle93611903s_tifle
stile54931573s_ti_le
strickle1467793strickle
subniche1554253subniche
swindle11389183swindle
swingle113510563swingle
swiple11379233s_wiple
taille63116923ta_ille
tangible1145603tangible
tangle74019953tan_gle
tunicae9328143tunicae
tunicles10217133tunicles
uncle7317053_un_cle
usance858013usan_c_e
utricle937913utricle
vagile10310543vagi_le
vanilla10238743vanilla
variole10711593variole
vehicle15175253vehicle
vernicle1346433vernicle
vesicle12217923vesicle
wandle105316663wan_dle
wangle103817503wan_gle
wavicles1633783wavicles
zanily18310183zani_ly

Search took 9 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 Limit1340272507.89316980.5
3Display Results2502500.0932688.2
 (SQL Overall)1786912508.37621333.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.