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

457 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
miles7464507(None) 
biles75542141biles
files85441271files
mailes84329111mailes
males75049791males
mikes115129891mikes
milds86422051milds
mile66352571mile_
miler75733061miler
milers84625161milers
milks115020581milks
milles84526561milles
mills75435051mills
milos75428011milos
mils66045331mil_s
milts75430711milts
mimes95732021mimes
mines75651951mines
mires75640881mires
mises74740561mises
mites75141801mites
mixes147224401mixes
moles74747921moles
mules75034291mules
piles74742611piles
riles55343641riles
smiles84522291smiles
tiles55542101tiles
wiles85437871wiles
ables75935542ables
aides65336602aides
ailed66240282ailed
ails45654712ail_s
aisles64721142aisles
ales47067102_ales
ambles105121862ambles
amices105018012amices
amides95722662amides
amies76837692ami_es
amines84727982amines
amoles84122192amoles
arles56735742arles
axles125219472axles
bales76250082bales
bibles104617642bibles
bices95029962bices
bides85536772bides
bikes117529472bikes
bile66147182bile_
bilges94915632bilges
bilks115117892bilks
bills75632862bills
bines76946792bines
birles84920642birles
bises75435622bises
bites75641172bites
bizes165923662bizes
boles75448602boles
chiles115425302chiles
cines75239682cines
cires74932912cires
cites74435582cites
coles76055062coles
dales66439742dales
deles65139252deles
dices86434242dices
dies55653522di_es
dikes105831332dikes
dills65530972dills
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
doles67843752doles
ediles74016982ediles
exiles134816402exiles
fices106031162fices
fifes114822392fifes
file75446642file_
filed95331902filed
filer85433002filer
filers94623722filers
filet85540162filet
filets94718952filets
filles94224522filles
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
flies85630712flies
gales65442482gales
gibes84422522gibes
gies55641422gi_es
gilds75417522gilds
gills64728192gills
gilts64924262gilts
gites65630182gites
gives95324872gives
guiles73919282guiles
gules64831042gules
hales85449842hales
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hires86134342hires
hives116925512hives
holes84748652holes
ices66129642_ices
ides57734232_ides
idles66720122idles
ilea45931462_ilea
ileus54616892_ileus
ilex115822032_ilex
ilks87218572_ilks
ills47030422_ills
imides94515342imides
imines84918352imines
ires45639282_ires
isles54220562isles
jibes145520322jibes
jills125122822jills
jilts124717412jilts
jives154820812jives
joles125230832joles
kales95730982kales
kibes115521112kibes
kikes85122552kikes
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kines95039132kines
kites95432542kites
les35663072__les
lies46454192li_es
likes96231902likes
lilies63021412lilies
lilos55821872lilos
lilts55822802lilts
limes75636502limes
lines57054572lines
lisles63416282lisles
lives86133192lives
mabes96331532mabes
maces97139962maces
macles107023222macles
maes66948392m_aes
mages85036022mages
maile75232222maile_
mailed95326752mailed
mailer84724182mailer
mailers94420332mailers
maills84215282maills
mails76037782mail_s
maizes175115732maizes
makes115336852makes
male66052292male_
malls76233432malls
malms95021552malms
malts76331752malts
manes76648952manes
maples104819422maples
mares76457632mares
mates75251362mates
maxes145629532maxes
mazes165632172mazes
melds84822382melds
melee73729102melee
melees83618082melees
mells75031332mells
mels65941532mel_s
melts74930102melts
memes94927702memes
meres75143572meres
merles85322762merles
metes74736212metes
mezes167719262mezes
mibs85330482mi_bs
micas96823052micas
mice87442232mice_
miches134320732miches
mickles153415002mickles
micks135525372micks
mics87435152mi_cs
middles113415302middles
midges103516472midges
midis85923412midis
midleg1038552midleg
midlegs1156322midlegs
mids76541782mi_ds
mien65028362mi_en
miens76118302miens
miffs134512882miffs
miggles113512032miggles
miggs96311372miggs
migs76935322mi_gs
mike105535292mike_
miked125020452miked
mil55752112mil__
milages103114402milages
milch124413372milch
mild75330852mil_d
milded104416152milded
milden94113152milden
mildens10339932mildens
milder93818452milder
mildest102812062mildest
mildew12319042mildew
mildews13365882mildews
milia72719572milia
milieu8314112milieu
milieus939802milieus
milk105028472mil_k
milked134612572milked
milker124814322milker
milkers134411612milkers
milky144014442milky
mill66541482mil_l
mille75029132mille
milled94326172milled
miller84625412miller
millers93621332millers
millet84030742millet
millets94216842millets
milneb1095952milneb
milnebs11113792milnebs
milo65536102mil_o
milpa92111402milpa
milpas101710272milpas
milreis937322milreis
milt65455812mil_t
milted93919942milted
milter84921232milter
milters93619082milters
milty104720072milty
mime85736402mime_
mimed105622732mimed
mimeo96018682mimeo
mimeos104511542mimeos
mimer94825762mimer
mimers105520182mimers
minas75434112minas
minces104420802minces
minds85427122minds
mine67256162mine_
mined85333352mined
miner76933542miner
miners84126632miners
mingles103719002mingles
minis75432992minis
minkes124618782minkes
minks115829272minks
mints76834042mints
minus75223932minus
minxes154612982minxes
mioses84318852mioses
mips85534082mi_ps
mire66748232mire_
mired85729222mired
mirex146816622mirex
mirks115122142mirks
mirs66940572mi_rs
mis58162622mi__s
mise66043582mise_
miser75430402miser
misers85025702misers
misled94719312misled
mislies92922282mislies
misos76523292misos
miss65339422mi_ss
misses85130872misses
mists76633902mists
mite66249412mite_
miter75734792miter
miters84328772miters
mitis75425992mitis
mitres83922072mitres
mitts75523752mitts
mixed155717252mixed
mixer145017642mixer
mixers154513562mixers
mizen164815272mizen
mizens174610252mizens
mizzles17329492mizzles
mobiles112813122mobiles
modes85537412modes
moiled94318862moiled
moiler84017262moiler
moilers93615202moilers
moils76125752moil_s
moires8915632moires
mokes114631032mokes
molas75132092molas
molds85324832molds
mole66251832mole_
molest85022742molest
molies84429512molies
molls75129782molls
mols65948572mol_s
molts76032092molts
momes95134472momes
mopes95134982mopes
mores76249642mores
motes75944002motes
motiles93317432motiles
moues75732842moues
moves106128422moves
mule65236972mule_
muled85824432muled
muley104819282muley
muleys11409642muleys
mulls75124152mulls
mures75937212mures
muses75134302muses
mutes75033782mutes
nides65229132nides
nills54926672nills
nils46132452nil_s
nines55937342nines
nites55736342nites
nixes124519622nixes
ogles65223182ogles
oiled64429472oiled
oiler54628282oiler
oilers64721192oilers
oils46337972oil_s
oles46453472_oles
orles55326212orles
pales75753802pales
peles75738082peles
pies66949602pi_es
pikes115031032pikes
pile65649692pile_
pilea75123952pilea
piled85232992piled
pilei74021782pilei
pileus84514942pileus
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pines76048862pines
pipes96030142pipes
pixes144323172pixes
plies74526512plies
poles75351002poles
pules74538812pules
rales54947492rales
ribes75530172ribes
rices75536152rices
rides66140812rides
riels55121332riels
rifles94217702rifles
rile45650532rile_
riled65833252riled
riley84420582riley
rilles64725502rilles
rills55032712rills
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
roles56747982roles
rules55234252rules
sales56055592sales
sices75637272sices
sides65838362sides
sidles74721152sidles
sikes96236082sikes
silds65520522silds
silex123417412silex
silks94620682silks
sills55135982sills
silos56029422silos
silts55330822silts
similes92915232similes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
smile74823922smile_
smiled93716432smiled
smiler83916682smiler
smilers94113842smilers
smiley114012302smiley
smileys12336322smileys
smites83921922smites
soles55547922soles
spiles84227912spiles
stiles64328762stiles
tales55451372tales
teles54536002teles
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tildes74513962tildes
tile45451442tile_
tiled64832942tiled
tiler56131022tiler
tilers63523492tilers
tills54631702tills
tils45739612til_s
tilts55325612tilts
times75630822times
tines54848422tines
tires55437492tires
titles63719922titles
toiles63923512toiles
toles55147132toles
tules54532792tules
umbles103817492umbles
vales85434262vales
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vile76139802vile_
viler86324162viler
vilest9416842vilest
vills86429322vills
vines85137642vines
vires84529682vires
vises84427772vises
voiles94616442voiles
voles86234042voles
wales86142832wales
whiles124418012whiles
wides94832822wides
wifes114522562wifes
wilds94818202wilds
wile75944372wile_
wiled95231552wiled
wills84528962wills
wilts85023502wilts
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
wyles114615322wyles
yikes125117752yikes
yills83921552yills
yipes106017842yipes
yules84521582yules
zills144020782zills
zines145232652zines

Search took 3 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.0961861364.6
2DLD Change Limit538004571.93627789.3
3Display Results4574570.1233715.4
 (SQL Overall)1786914572.15582919.3
 
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.