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

261 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
panicles12101011(None) 
panicle11129981panicle_
panicled13106781panicled
sanicles10149941sanicles
calicles123811432calicles
canticles1339182canticles
funicles13246832funicles
manacles1239522manacles
manilles102312602manilles
maniples12269422maniples
painches1588912painches
panaches15310292panaches
panicked1785172panicked
panics103815362panic__s
panicums1444742panicums
panoches1548122panoches
pantiles103617152pantiles
particles1339802particles
pedicles1338682pedicles
pinocles1248692pinocles
radicles11249702radicles
sanicle91210262sanicle_
tunicles10217132tunicles
wavicles1633782wavicles
aisles64721143_a_isles
amices105018013_amic_es
aneles64626293_an_eles
angles74426703_an_gles
anile54634463_ani_le_
anils56326723_ani_l_s
animes84719593_ani_mes
anises64826693_ani_ses
anisoles81010123_anisoles
ankles104818383_an_kles
anoles64827433_an_oles
apices104916263_apic_es
articles10310243articles
auricles10138333auricles
babiches1735253babiches
bangles103617413ban_gles
banishes131812463banishes
barnacles1355333barnacles
bernicles1345403bernicles
binocles1236413binocles
calices114321693calic_es
caliches153812273caliches
calicle113111433calicle_
calicoes123911603calicoes
calycles15295693calycles
canailles1148273canailles
cancels114113313can_cels
candles104422343can_dles
canines93724033cani_nes
canities101519263canities
canticle1239703canticle_
cantles94721413can_tles
carices114220953caric_es
carioles10817073carioles
caulicles1344383caulicles
cenacles1238023cenacles
chicles143512503_chicles
clavicles1643673clavicles
cornicles1368243cornicles
cubicles1435883cubicles
cuticles1237893cuticles
dances95120653dan_c_es
dandles94218533dan_dles
dangles93618423dan_gles
danishes121710493danishes
darioles9710693darioles
denticles1237753denticles
enisles72312603_enisles
failles102914133fa_illes
fancies124018783fan_cies
fanciless1444603fanciless
fascicles1664263fascicles
funicle12237483funicle_
ganaches1437433ganaches
hances115621283han_c_es
handles114020653han_dles
hantles104117513han_tles
icicles1135943_icicles
jangles154015683jan_gles
kanteles1238123kanteles
lances84824103lan_c_es
latices9313763latic_es
macles107023223ma__cles
mailes84329113ma_i_les
malices114316623malic_es
manacle11310283manacle_
manacled1336453manacled
manches143818623man_ches
manciples1564793manciples
mandibles1445543mandibles
mangles104021463man_gles
manholes13311183manholes
manics103919933manic__s
manicures1346263manicures
manilas93915873mani_las
manillas102611163manillas
manille92613273manille_
maniple11249653maniple_
mantles94820703man_tles
monocles12310673monocles
nances83618643nan_c_es
nancies93516843nan_cies
niches114419143__niches
nickles133713823__nickles
nuncles939843nun_cles
ossicles1054183ossicles
paces96741113pa__c_es
pacifies15311223pacifies
paddles113515643pa_ddles
padles95221123pa__dles
pails75833063pa_i_l_s
painless10108343pa_inless
paisley1235553pa_isley
paisleys1333343pa_isleys
palaces114216463palac_es
pales75753803pa___les
panacea1137793panac_ea
panaceas1236763panaceas
panache1458433panache_
pancakes1637073pancakes
pancreas1235393pan_creas
pandies104224503pan_dies
pandores11312453pandores
paneled10612573pan_eled
paneless102611763pan_eless
panelled1138963panelled
panels84716523pan_el_s
panes76148693pan___es
panfishes1737593panfishes
panfries13149203panfries
panfuls1237173panful_s
pangenes112612823pangenes
panic93923903panic___
panically16310433panically
panickier1743173panickier
panickiest1843493panickiest
panicky1833853panic_ky
panicum1346393panic_um
panier84425503pani__er
paniers94717333pani_ers
panmixes1934913panmixes
pannes85522853pan__nes
panochas1545653panochas
panoche1456383panoche_
panoplies1346003panoplies
panpipes1135173panpipes
pansies94521983pan_sies
pantalet10415903pantalet
pantalets1147673pantalets
panties94230933pan_ties
pantile93918483pantile_
pantiled113111593pantiled
pantofles1474863pantofles
pantries101817393pantries
papacies1439483papacies
papules112411573pa_pules
parables121613563parables
parcels113712663pa_rcels
parches143720003pa_rches
paries84742513pari__es
parietes10714543parietes
parises94827183pari_ses
parishes13314753parishes
parities10522973parities
parles86334403pa__rles
paroles95025883pa_roles
particle1239533particle_
pastiches1637453pastiches
pastilles1148703pastilles
patches143320383pa_tches
patines95225763pati_nes
paunches1568173paunches
pavises125315493pavi_ses
pavisses13397103pavisses
payables15166483payables
pedicels1336253pedicels
pedicle1238973pedicle_
pedicled1436463pedicled
pellicles1344923pellicles
pencels113610053pen_cels
penciled1337823penciled
penciler1237113penciler
pencilers1345643pencilers
pencils113011773pencil_s
penicils1247863penicils
penile82219603peni_le_
penises9318193peni_ses
penoches1538933penoches
pentacles1338773pentacles
penuches1536943penuches
penuchles1643763penuchles
penuckles1743243penuckles
petioles10311643petioles
pickles153215443p__ickles
piles74742613p__i_les
pinches144117933pin_ches
pinholes131810663pinholes
pinites9319533pini_tes
pinnacles13276043pinnacles
pinnules1036463pinnules
pinochles1644863pinochles
pinocle1138143pinocle_
pinoles93418703pin_oles
pintles94118723pin_tles
pinwales1367963pinwales
plaices11411143plaic_es
planches153111863plan_ches
planishes14138523planishes
polices113118053polic_es
policies122415663policies
ponces104720843pon_c_es
ponies84833463poni__es
popsicles1543663popsicles
potiches1539203potiches
prances113618773pran_c_es
prices104524543p_ric_es
prickles162511093p_rickles
princes113015143princ_es
pumices1338273pumic_es
punches144816133pun_ches
pungles104013713pun_gles
punishes1338113punishes
radicels11297183radicels
radices102314263radic_es
radicle103510713radicle_
rances84625443ran_c_es
ranches123620113ran_ches
rankles113114543ran_kles
reticles103912483reticles
saices84221803sa_ic_es
sanies63031953sani__es
sanities81219773sanities
seniles72618023seni_les
silicles1037073silicles
spadices1336093spadic_es
spadilles1244993spadilles
spancels1245273span_cels
spangles1138893span_gles
spaniels1045963spaniel_s
spansules1143613spansules
tailles72516473ta_illes
tangibles1243953tangibles
tangles83920043tan_gles
tunicle9308033tunicle_
uncles8317163_un_cles
utricles1037223utricles
vanillas11228123vanillas
vanishes141610753vanishes
vanities111414493vanities
varices123313573varic_es
varioles11711123varioles
vehicles16204683vehicles
vernicles1446133vernicles
vesicles13127073vesicles
wangles113416933wan_gles
wavicle1534063wavicle_
zanies153219673zani__es

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622617.05020732.2
3Display Results2612610.1062462.3
 (SQL Overall)1786912617.59223536.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.