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
modi7682631(None) 
midi75628471midi
mod69054401mod_
mode75840301mode
mods77945051mods
momi87524481momi
nodi56626741nodi
bidi78226572bidi
bod67055542bod_
bode75838752bode
bods76244712bods
body107425672body
cadi75732182cadi
cedi74919272cedi
cod69660122cod_
coda77029342coda
code77347732code
cods76848102cods
coni65534802coni
dodo66024912dodo
emodin9310352emodin
foci94521012foci
gadi66329722gadi
god57449792god_
gods65438042gods
hod76852462hod_
hods87239862hods
iodic84816752iodic
iodid74315532iodid
iodin64419352iodin
kadi96224822kadi
koi77534752ko_i
koji155611122koji
loci66126282loci
lode56240112lode
loid55531492loid
loti46431842loti
mad68958712mad_
made75440242made
mads76845372mads
magi76329532magi
maid75537662maid
maxi137023562maxi
med66146742med_
media84721712media
medic104619652medic
medii84513492medii
meds75735362meds
mi48249052m__i
mid67354462mid_
midis85923412midis
mids76541782mids
mini65634562mini
miri66730372miri
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
mud67336862mud_
muds75530652muds
muni65824412muni
myoid11512992myoid
nidi56524392nidi
nod47549562nod_
node513036882node
nods55838222nods
nori47133142nori
obi57127732_obi
od39255242_od_
oda48133042_oda
odd57725452_odd
ode47446582_ode
odic74920572_odic
ods47546212_ods
oi29061482_o_i
padi76331782padi
pod66351482pod_
podia8415282podia
pods76540152pods
poi57244662po_i
qadi145621102qadi
rod47953892rod_
rode55844302rode
rods56442062rods
roti46332932roti
sadi55834642sadi
sod46053702sod_
soda56329382soda
sodic84917492sodic
sods54940212sods
soldi65717202soldi
soli46637012soli
sori46039842sori
tod49457072tod_
tods56141842tods
tody86327212tody
tondi65716142tondi
topi67830392topi
tori47542152tori
void86220562void
wadi86228172wadi
yod77545502yod_
yodh119916102yodh
yods86531182yods
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.0762351197.4
2DLD Change Limit298721870.94031778.7
3Display Results1871870.0464065.2
 (SQL Overall)1786911871.062168258.9
 
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.