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

300 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
miler7573306(None) 
filer85433001filer
mailer84724181mailer
milder93818451milder
mile66352571mile_
milers84625161milers
miles74645071miles
milker124814321milker
miller84625411miller
milter84921231milter
mimer94825761mimer
miner76933541miner
miser75430401miser
miter75734791miter
mixer145017641mixer
moiler84017261moiler
oiler54628281oiler
smiler83916681smiler
tiler56131021tiler
viler86324161viler
abler75624312abler
aider65431132aider
ailed66240282ailed
aimer75926822aimer
airer54927892airer
aiver85725162aiver
ambler104916452ambler
ampler104313302ampler
bailer85425252bailer
baler75635272baler
bider85728372bider
bier65531832bi_er
biker116022562biker
bile66147182bile_
biles75542142biles
bilker124913442bilker
biller84923482biller
biner75930692biner
birler85715082birler
biter75030032biter
boiler84319272boiler
ceiler84013962ceiler
cider84723312cider
citer74827332citer
coiler84421592coiler
dialer74315432dialer
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
eider64624742eider
eviler94811892eviler
exiler134712182exiler
fiber104921132fiber
fifer115519972fifer
filar84819292filar
file75446642file_
filed95331902filed
filers94623722filers
files85441272files
filet85540162filet
filler94623622filler
filmer114112402filmer
filter94517632filter
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flier86023402flier
giber85417702giber
gilder84415532gilder
giller74519732giller
giver94921202giver
hailer94720342hailer
haler85033522haler
hider95024082hider
hiker125119392hiker
hilar85418142hilar
hiller94421632hiller
hirer85423122hirer
idler65015662idler
ilea45931462_ilea
ilex115822032_ilex
iller54821292iller
jailer134316682jailer
jiber145115702jiber
jilter133512512jilter
jiver155119052jiver
kier86526812ki_er
killer104917952killer
kilter103714342kilter
kiter95523212kiter
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
liter54736342liter
liver85132962liver
macer912126942macer
maile75232222maile_
mailed95326752mailed
mailers94420332mailers
mailes84329112mailes
maimer104514592maimer
maker114127812maker
malar76424442malar
male66052302male_
males75049792males
maser75029972maser
mater74438862mater
mauler84416712mauler
mazer165722422mazer
melder93915812melder
melee73729102melee
melter83520112melter
merer75126232merer
meter75130322meter
mewler113510232mewler
mice87442232mice_
mickler153310232mickler
middler112712272middler
midleg1038552midleg
mien65028362mi_en
mike105535292mike_
miked125020452miked
mikes115129892mikes
mil55752112mil__
milch124413372milch
mild75330852mil_d
milded104416152milded
milden94113152milden
mildew12319042mildew
milds86422052milds
milia72719572milia
milieu8314112milieu
milk105028472mil_k
milked134612572milked
milkers134411612milkers
milkier133411162milkier
milks115020582milks
milky144014442milky
mill66541482mil_l
mille75029132mille
milled94326172milled
millers93621342millers
milles84526562milles
millet84030742millet
millier93716702millier
mills75435052mills
milneb1095952milneb
milo65536102mil_o
milord999572milord
milos75428012milos
milpa92111402milpa
mils66045332mil_s
milt65455812mil_t
milted93919942milted
milters93619092milters
miltier93214962miltier
milts75430712milts
milty104720072milty
mime85736402mime_
mimed105622732mimed
mimeo96018682mimeo
mimers105520182mimers
mimes95732022mimes
mincer104017362mincer
minder94822502minder
mine67256172mine_
mined85333352mined
miners84126632miners
mines75651952mines
mingler104213842mingler
minor74920062minor
minter84425102minter
mir57046772mi__r
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirker123712692mirker
mise66043582mise_
misers85025702misers
misery114113542misery
mises74740562mises
misled94719312misled
mister84728562mister
mite66249412mite_
miters84328782miters
mites75141802mites
mither114218562mither
mitier83620672mitier
mitre75522422mitre
mixed155717252mixed
mixers154513562mixers
mixes147224402mixes
mizen164815272mizen
moiled94318862moiled
moilers93615202moilers
molar75223092molar
molder93819272molder
mole66251832mole_
moles74747922moles
molter84119422molter
moper94925922moper
mover104220862mover
mower104523452mower
mule65236972mule_
muled85824432muled
mules75034292mules
muley104819282muley
muller83820352muller
muser76024122muser
muter74525542muter
mylar105311532mylar
nailer64119362nailer
nicer74618292nicer
niter55028972niter
ogler65917442ogler
oiled64429472oiled
oilers64721192oilers
oilier64417232oilier
paler75436932paler
pier66035292pi_er
piker115622842piker
pilar75221502pilar
pile65649692pile_
pilea75123952pilea
piled85232992piled
pilei74021782pilei
piles74742612piles
pilfer1139162pilfer
piper96523192piper
plier75221282plier
poler74431792poler
puler74826622puler
railer64524932railer
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rifler94014262rifler
rile45650532rile_
riled65833252riled
riles55343642riles
riley84420582riley
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
ruler54923342ruler
sailer63526102sailer
sidler74716962sidler
siker95326032siker
silex123417412silex
siller64026062siller
silver93815812silver
siver85728612siver
sizer145521812sizer
slier54827242slier
smile74823922smile_
smiled93716432smiled
smilers94113852smilers
smiles84522292smiles
smiley114012302smiley
smiter83616412smiter
tailer63823732tailer
taler56034862taler
tier44936142ti_er
tiger65718632tiger
tile45451442tile_
tiled64832942tiled
tilers63523502tilers
tiles55542102tiles
tiller64222542tiller
tilter63417692tilter
timer75626042timer
titer55430612titer
toiler63918282toiler
veiler93814352veiler
vier75428152vi_er
vile76139802vile_
viper105017302viper
wailer93720322wailer
waler84229262waler
wider94826352wider
wilder103616472wilder
wile75944372wile_
wiled95231552wiled
wiles85437872wiles
wilier93217072wilier
willer94021062willer
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver

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.313570897.8
2DLD Change Limit538003001.73331044.4
3Display Results3003000.0803750.0
 (SQL Overall)1786913002.12684050.3
 
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.