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

198 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
milos7542801(None) 
filos86125381filos
kilos95021471kilos
lilos55821871lilos
milds86422051milds
miles74645071miles
milks115020581milks
mills75435051mills
milo65536101milo_
mils66045331mil_s
milts75430711milts
misos76523291misos
silos56029431silos
ails45654712ail_s
amigos94511212amigos
bigos85020012bigos
bilbos105011202bilbos
biles75542142biles
bilks115117892bilks
bills75632862bills
bios66335322bi_os
biros75325132biros
bolos75531372bolos
calos74431902calos
didos76820812didos
dildos8179302dildos
dills65530972dills
dinos65428062dinos
diols65521012diols
eidos65817752eidos
fidos95819052fidos
files85441272files
fillos94415082fillos
fills84632372fills
films105617962films
filo76034282filo_
filose96112502filose
fils75838692fil_s
finos86226952finos
gilds75417522gilds
gills64728192gills
gilts64924262gilts
giros65722652giros
halos85230252halos
helos84928062helos
hillos94618892hillos
hills85431352hills
hilts86924412hilts
hilus84817642hilus
ilks87218572_ilks
ills47030422_ills
jills125122822jills
jilts124717412jilts
kills94526172kills
kilns95112982kilns
kilo86028672kilo_
kilts95122182kilts
kinos96626142kinos
kolos94921212kolos
lidos65219882lidos
lilo46731562lilo_
lilts55822802lilts
limos75320812limos
linos55631502linos
mailes84329112mailes
maills84215282maills
mails76037782mail_s
makos116518362makos
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
manos74933622manos
mayos105521932mayos
melds84822382melds
mells75031332mells
melon73922082melon
melons84117712melons
mels65941532mel_s
melts74930102melts
memos95719112memos
mhos95517772m_hos
miaou7513082miaou
miaous8511692miaous
miaow1058352miaow
miaows1145472miaows
mibs85330482mi_bs
micas96823052micas
micks135525372micks
micros104115362micros
mics87435152mi_cs
midis85923412midis
mids76541792mi_ds
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935322mi_gs
mikes115129892mikes
mikvos1554022mikvos
mil55752112mil__
milch124413372milch
mild75330852mil_d
mile66352572mil_e
miler75733062miler
milers84625162milers
milia72719572milia
milk105028472mil_k
milky144014442milky
mill66541482mil_l
mille75029132mille
milles84526562milles
milord999572milord
milords10117852milords
milpa92111402milpa
milpas101710272milpas
milt65455812mil_t
milty104720072milty
mimeos104511542mimeos
mimes95732022mimes
mimosa1036362mimosa
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
minor74920062minor
minors85117102minors
mints76834042mints
minus75223932minus
mips85534082mi_ps
mires75640882mires
mirks115122142mirks
mirs66940572mi_rs
mis58162622mi__s
mises74740562mises
miso67229902miso_
miss65339422mi_ss
mists76633902mists
mites75141802mites
mitis75425992mitis
mitts75523752mitts
mixes147224402mixes
moils76125752moil_s
mojos145314462mojos
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monos75930862monos
mools76027172mools
moos66051302m_oos
mos57067122m__os
mozos165516332mozos
mules75034292mules
mulls75124152mulls
nills54926672nills
nils46132452nil_s
nolos54423352nolos
oils46337972oil_s
olios54520852olios
piles74742612piles
pilis75825202pilis
pills74130972pills
pilose84514242pilose
pilot77435062pilot
pilots84018872pilots
pilous84717752pilous
pilus75921062pilus
pisos76021062pisos
polos76129912polos
riles55343642riles
rills55032712rills
siglos7311472siglos
silds65520522silds
silks94620682silks
sills55135992sills
silo46037912silo_
silts55330822silts
smiles84522292smiles
solos54830792solos
telos55424522telos
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
tiros54524892tiros
vills86429322vills
vinos84723072vinos
viols86118102viols
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winos84625042winos
yills83921552yills
zills144020782zills

Search took 5 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 Filter178691538000.736242786.7
2DLD Change Limit538001984.04613297.1
3Display Results1981980.0633142.9
 (SQL Overall)1786911984.84536881.5
 
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.