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 “modi” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

187 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
modi7682632(None) 
midi75628491midi
mod69054411mod_
mode75840311mode
mods77945061mods
momi87524481momi
nodi56626751nodi
bidi78226602bidi
bod67055552bod_
bode75838762bode
bods76244722bods
body107425682body
cadi75732192cadi
cedi74919282cedi
cod69660132cod_
coda77029352coda
code77347742code
cods76848112cods
coni65534802coni
dodo66024922dodo
emodin9310352emodin
foci94521012foci
gadi66329732gadi
god57449802god_
gods65438052gods
hod76852472hod_
hods87239872hods
iodic84816752iodic
iodid74315532iodid
iodin64419352iodin
kadi96224842kadi
koi77534762ko_i
koji155611132koji
loci66126282loci
lode56240122lode
loid55531502loid
loti46431842loti
mad68958722mad_
made75440252made
mads76845382mads
magi76329532magi
maid75537672maid
maxi137023562maxi
med66146752med_
media84721712media
medic104619652medic
medii84513492medii
meds75735372meds
mi48249062m__i
mid67354482mid_
midis85923422midis
mids76541802mids
mini65634572mini
miri66730382miri
mo49158482mo__
moa57249182mo_a
moan65832022moan
moas65545342moas
moat66352032moat
mob78651922mo_b
mobs85737372mobs
moc77845082mo_c
mock126429442mock
mocs85834902mocs
modal85919242modal
model84521692model
modem103717142modem
modes85537412modes
modica11310062modica
modify1537172modify
modish123813542modish
moduli9267962moduli
modus85417202modus
mog66949672mo_g
mogs75439332mogs
moil65534092moil
mojo136917222mojo
moke106234222moke
mol56654592mo_l
mola66035632mola
mold76034332mold
molds85324832molds
moldy115014652moldy
mole66251832mole
moll66735702moll
mols65948572mols
molt66356162molt
moly96031912moly
mom78853162mo_m
mome85239352mome
moms86539482moms
mon57561582mo_n
monde85723142monde
mondo85721232mondo
monie75631652monie
monk105928522monk
mono66036722mono
mons68152262mons
mony96830012mony
moo58460512mo_o
mood76332062mood
moods85224622moods
moody115017492moody
mool67533862mool
moon67140812moon
moor66628552moor
moos66051302moos
moot67653622moot
mop76950822mo_p
mope86838042mope
mops85940132mops
mopy115721972mopy
mor56855002mo_r
mora66641272mora
more67154522more
morn66237562morn
mors65950062mors
mort66758832mort
mos57067122mo_s
mosh95227602mosh
mosk105622442mosk
moss67641032moss
most66554202most
mot57279422mo_t
mote67048082mote
moth96731332moth
motif10519682motif
mots66853162mots
mott66648442mott
moue65835572moue
move96630722move
movie105319132movie
mow86650352mo_w
mown95424442mown
mows96340832mows
moxa136917742moxa
moxie144018122moxie
mozo157719742mozo
mud67336872mud_
muds75530662muds
muni65824412muni
myoid11512992myoid
nidi56524412nidi
nod47549572nod_
node513036892node
nods55838232nods
nori47133142nori
obi57127732_obi
od39255252_od_
oda48133052_oda
odd57725462_odd
ode47446592_ode
odic74920582_odic
ods47546222_ods
oi29061492_o_i
padi76331792padi
pod66351492pod_
podia8415282podia
pods76540162pods
poi57244662po_i
qadi145621112qadi
rod47953902rod_
rode55844312rode
rods56442072rods
roti46332932roti
sadi55834652sadi
sod46053712sod_
soda56329392soda
sodic84917492sodic
sods54940222sods
soldi65717202soldi
soli46637012soli
sori46039842sori
tod49457082tod_
tods56141852tods
tody86327222tody
tondi65716142tondi
topi67830392topi
tori47542152tori
void86220572void
wadi86228182wadi
yod77545512yod_
yodh119916112yodh
yods86531192yods
yogi86120422yogi
yoni77524392yoni
zori137722922zori

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721870.93631914.5
3Display Results1871870.0306233.3
 (SQL Overall)1786911871.232145041.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.