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

123 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
micelle117834(None) 
micell1098191micell_
micella11106831micella
micellae1295721micellae
micelles1288831micelles
micells11107681micells
micellar12105572micellar
mickle143715132mic_kle
mille75029132mi__lle
morelle91210802morelle
mycele1335852myce_le
nacelle938152nacelle
amarelle1045613amarelle
amicable1438433amicable
belle75827833__belle
bicycle1643993bicycle
cadelle1039923cadelle
cell65031723__cell_
cella75420313__cella
cellae84915933__cellae
celled94420323__celled
celli76717693__celli
cello74919583__cello
cells75428063__cells
cicale10314503cic_ale
cicelies1269753cicelies
cicely1338833cice_ly
cineole91010003cineole
echelle1246623echelle
excelled18125703excelled
fickle153912973fic_kle
fictile1238023fictile
fille84327403fi__lle
gabelle10259213gabelle
gazelle17236333gazelle
girolle835793girolle
icelike1337173_icelike
icicle1036583_icicle
impelled1336073impelled
impeller1236083impeller
libelee92510983libelee
libelled11317213libelled
libellee10227733libellee
libeller10297433libeller
licence11119373licence
license9148423license
licente91210893licente
mackle143716433mac_kle
macle96127003mac__le
maculae113412863maculae
macule104115273mac_ule
manille92613273manille
marcelled1445203marcelled
marceller1345153marceller
melee73729103m__elee
mell64935613m__ell_
melled95023023m__elled
mells75031333m__ells
merle75824373m__erle
mice87442233mic___e
miche126219243mic__he
mickler153310233mickler
mickles153415003mickles
microbe1338663microbe
middle103414983mi_ddle
midsole1037813midsole
miggle104012113mi_ggle
mile66352573mi___le
mileage10299313mileage
mill66541483mi__ll_
milled94326173mi__lled
miller84625413mi__ller
milles84526563mi__lles
millet84030743mi__llet
mills75435053mi__lls
minable112315073minable
mineable121611053mineable
mingle93518783mi_ngle
miocene1147923mioce_ne
mirabelle1343333mirabelle
miracle1138843miracle
misally121111063misally
miscall1139653miscall_
miscalled1447443miscalled
miscaller1346283miscaller
miscalls1239003miscalls
miscible1447673miscible
misease92713043misease
miserly12329823miserly
misfile122611553misfile
mislie83219153mi_slie
misrule939353misrule
missile92815403missile
mixable18259173mixable
mixedly2033983mixedly
mixible18195093mixible
mizzle16279993mi_zzle
modelled1236433modelled
modeller1136613modeller
morelles10710493morelles
morello9117793morello
mouille937843mouille
muckle143413583muc_kle
myceles1435213myceles
mycelia1444843mycelia
nacelles1048393nacelles
nicely1139493nice_ly
nickelled1653793nickelled
nickle123814483nic_kle
nielli636303ni_elli
niello636603ni_ello
nigella844523nigella
novelle1058233novelle
nucelli944723nucelli
ocelli836843_ocelli
pickle144215653pic_kle
pizzelle1842913pizzelle
rille55728733ri__lle
roselle7310243roselle
selle54428313__selle
sickle124418323sic_kle
spinelle1046223spinelle
tickle124616743tic_kle

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.390458182.1
2DLD Change Limit1340271236.31321230.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.74926476.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.