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

320 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
micell109819(None) 
micella11106821micella
micelle1178341micelle
micells11107681micells
cell65031722__cell
cicely1338832cicely
mell64935612m__ell
mice87442232mice__
micellae1295722micellae
micellar12105572micellar
micelles1288832micelles
mickle143715132mickle
mill66541482mi__ll
miscall1139642miscall
mycele1335852mycele
nicely1139492nicely
ainsell796393ainsell
amice96122873amice__
amices105018013amice_s
bedell93610043bedell
befell11428713befell
bell66237183__bell
bice86235563bice__
bicep115413543bice_p
biceps12447713biceps
bices95029963bice_s
bield84614653bi_eld
bill67239943bi__ll
call66838673__call
ceil65725063__ceil
cel56040553__ce_l
cella75420313__cella
celli76717693__celli
cello74919583__cello
cells75428063__cells
cels65534973__cels
celt65646713__celt
cicala10310053cicala
cicale10314503cicale
cicero1048503cicero
cineol8108203cineol
cull65929643__cull
dell56938203__dell
dice75841893dice__
diced95824683dice_d
dicer85426423dice_r
dicers94720743dicers
dices86434243dice_s
dicey114819333dice_y
diel59034603di_e_l
dill55239973di__ll
direly10311553direly
dwell9519853_dwell
ell36735683___ell
excel1437743exce_l
excels1536663excels
fell76833073__fell
fice95737113fice__
fices106031163fice_s
fickle153912973fickle
fickly18318533fickly
field95015323fi_eld
fill75540193fi__ll
finely123011563finely
gill56336183gi__ll
gimel8313353gime_l
gimels938893gimels
hell75637893__hell
hill76439493hi__ll
ice56737243_ice__
iced78721893_ice_d
icefall1254303_icefall
ices66129643_ice_s
icily101211693_icily
ideal65716393_ideal
idyll9436713_idyll
ileal56118083_ileal
ill37437093_i__ll
impel95711773impe_l
impels10389523impels
jell117125873__jell
jill116430263ji__ll
kill85533173ki__ll
knell94210923_knell
kvell12436693_kvell
libel74116103libe_l
libels85112693libels
lice66045063lice__
likely13328133likely
lineal65616023lineal
lively123310813lively
mace87345783mace__
maced108528693mace_d
macer912126943mace_r
macers105321273macers
maces97139963mace_s
mackle143716433mackle
macle96127003mac_le
macled116718113macled
macles107023223macles
macula103013673macula
macule104115273macule
maill74420793m_aill
mall64639363m__all
marcel103714853marce_l
marcels113212373marcels
maxwell1942513maxwell
meal65643173m__eal
mel56047483m__e_l
meld75830473m__eld
mells75031333m__ells
mels65941533m__els
melt65752893m__elt
merely111312583merely
merl65830973m__erl
mewl95618323m__ewl
miaul71612123mi_aul
miauls8178713miauls
mic77647643mic___
mica86428253mic__a
micas96823053mic_as
miche126219243mic_he
miched143913393miched
miches134320733miches
mick126333433mic__k
mickey174211853mickey
mickeys18447943mickeys
mickler153310233mickler
mickles153415003mickles
micks135525373mic_ks
micra96214973mic_ra
micro94715993mic_ro
micron103714283micron
micros104115363micros
mics87435153mic__s
midcult1246303midcult
middle103414983middle
midleg1038553midleg
mien65028363mi_e_n
miens76118303mi_ens
miggle104012113miggle
mike105535293mike__
miked125020453mike_d
mikes115129893mike_s
mil55752113mi___l
mild75330853mi__ld
mildly12318243mildly
mile66352573mi__le
miler75733063mile_r
milers84625163milers
miles74645073mile_s
milk105028473mi__lk
mille75029133mi_lle
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
mills75435053mi_lls
milo65536103mi__lo
mils66045333mi__ls
milt65455813mi__lt
mime85736403mime__
mimed105622733mime_d
mimeo96018683mime_o
mimeos104511543mimeos
mimer94825763mime_r
mimers105520183mimers
mimes95732023mime_s
mince95325233mince__
minced114114913mince_d
mincer104017363mince_r
mincers113714853mincers
minces104420803mince_s
mine67256163mine__
mined85333353mine_d
miner76933543mine_r
mineral9312733mineral
miners84126633miners
mines75651953mine_s
mingle93518783mingle
miocene1147923miocene
mire66748233mire__
mired85729223mire_d
mires75640883mire_s
mirex146816623mire_x
misally121111063misally
misbill1137033misbill
miscalls1239003miscalls
misdeal1037663misdeal
mise66043583mise__
miseat82925703miseat
miser75430403mise_r
miserly12329823miserly
misers85025703misers
misery114113543misery
mises74740563mise_s
miskal123710263miskal
misled94719313misled
misrely12319603misrely
missal84314903missal
missel85216523missel
missels94614813missels
misspell1244303misspell
mite66249413mite__
miter75734793mite_r
miters84328783miters
mites75141803mite_s
mitral81314323mitral
mixed155717253mixe_d
mixedly2033973mixedly
mixer145017643mixe_r
mixers154513563mixers
mixes147224403mixe_s
mizen164815273mize_n
mizens174610253mizens
mizzle16279993mizzle
mizzly19256103mizzly
model84521693mode_l
models94216353models
mohel104914833mohe_l
mohels115011323mohels
moll66735703m__oll
morel75729093more_l
morelle91210803morelle
morello9117793morello
morels84820013morels
motel76623243mote_l
motels83616893motels
muchly1686203muchly
muckle143413583muckle
mull65128803m__ull
multicell1345523multicell
mutely113811653mutely
myceles1435213myceles
mycelia1444843mycelia
mycelial1543433mycelial
myself1445593myself
nacelle938153nacelle
nice65534713nice__
nicer74618293nice_r
nicest82315663nicest
nicety1138433nicety
nickel123811343nickel
nickels13338653nickels
nickle123814483nickle
nicol71113293nic_ol
nicols8810243nicols
nielli636303ni_elli
niello636603ni_ello
nigella844523nigella
nill45634303ni__ll
nucelli944723nucelli
ocelli836843_ocelli
pical95524373pic_al
pice84641093pice__
pickle144215653pickle
picul95015363pic_ul
piculs103511753piculs
pill65339463pi__ll
pineal84817683pineal
pixel143911903pixe_l
pixels15478533pixels
quell144311423_quell
recall83815723recall
refell94214443refell
resell64215203resell
retell63813643retell
rice64942913rice__
riced85825543rice_d
ricer74726613rice_r
ricers84120993ricers
rices75536153rice_s
richly1438003richly
rictal83113183rictal
riel46432383ri_e_l
riels55121333ri_els
rifely123710033rifely
rill45140903ri__ll
ripely112511153ripely
scall74420373_scall
scull75315763_scull
sell45840613__sell
shell84424123_shell
sice65545593sice__
sices75637273sice_s
sickle124418323sickle
sickly153110483sickly
sill45545153si__ll
skell94915833_skell
smell74916233_smell
snell54517303_snell
spell75020303_spell
subcell1146743subcell
swell84815983_swell
tell44934703__tell
tical76021493tic_al
ticals83214713ticals
tickle124616743tickle
till45941203ti__ll
timely113410113timely
tineal66216163tineal
unsell63512543unsell
unwell9349443unwell
upwell11285793upwell
vice95732853vice__
viced115118183vice_d
vices105725533vice_s
vilely1239443vilely
vill75235073vi__ll
vineal94814743vineal
well75832043__well
widely133311033widely
wield95213913wi_eld
wifely15429423wifely
will75737513wi__ll
wisely122711713wisely
yell76028323__yell
yield9519693yi_eld
yill75628973yi__ll
zill135727613zi__ll

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.1401276364.3
2DLD Change Limit1127163205.76619548.4
3Display Results3203200.1102909.1
 (SQL Overall)1786913206.01629702.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.