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

258 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
mien6502836(None) 
gien56330021gien
lien45339801lien
men59252851m_en
miens76118301miens
mine67256171mine
mizen164815271mizen
ain37579092ai_n
airn46433832airn
alien56425582alien
amen66733152amen
amie66339852amie_
amies76837692amies
amin66042252ami_n
amine75835382amine
been65335782been
ben56554922_ben
bier65531832bier
bin56658642bi_n
bine66650862bine
bren65629562bren
cine66242942cine
cion613330912cion
den47554342_den
die46759652die_
died66137852died
diel59034602diel
diene65720132diene
dies55653522dies
diet57357532diet
din46459462di_n
dine55555332dine
dizen155214932dizen
en28052392__en
even75222272even
eyen76223662eyen
fen66851352_fen
fie67152442fie_
fief107331362fief
fiend95312982fiend
fin66458032fi_n
fine75147952fine
firn76927502firn
gaen57329602gaen
gen45950512_gen
gie47149542gie_
gied64631982gied
gies55641422gies
gin46055752gi_n
girn56026862girn
given95915282given
glen56027202glen
haen76229452haen
hen67555272_hen
hie67652702hie_
hied85434042hied
hies74842832hies
hin67559562hi_n
hisn79620932hisn
imine75821062imine
in28150862_i_n
inn36727432_inn
ion36051022_ion
jin106443932ji_n
jinn115420242jinn
keen84830412keen
ken76343982_ken
kief117128412kief
kier86526812kier
kiln85620982kiln
kin76353972ki_n
kine85643432kine
kirn87123442kirn
lie38264522lie_
lied55838092lied
lief76036992lief
liens56525502liens
lier45942462lier
lies46454192lies
lieu46534362lieu
liken911818842liken
limen75426032limen
limn66527692limn
lin37967372li_n
line46965572line
linen55728722linen
linn46034592linn
lion46334442lion
liven85021732liven
mae57659112mae_
maes66948402maes
maiden93512282maiden
main65345522main
man57465872m_an
mane65052032mane
maun65727212maun
maven104816892maven
mawn94424142mawn
me47748332m_e_
mean65538092mean
med66146742m_ed
meed74934702meed
meek105624832meek
meet65350552meet
meg66040952m_eg
meiny104015412meiny
mel56047482m_el
mem77943472m_em
mend75334032m_end
meno66031362m_eno
menu65130232m_enu
met56072432m_et
mew86137732m_ew
mi48249052mi__
mib76946122mi_b
mibs85330482mibs
mic77647642mi_c
mica86428252mica
mice87442232mice
mick126333432mick
mics87435152mics
mid67354472mi_d
midden104112852midden
midi75628482midi
mids76541792mids
miff125625062miff
mig65646082mi_g
migg85716802migg
migs76935322migs
mike105535292mike
miked125020452miked
mikes115129892mikes
mil55752112mi_l
mild75330852mild
milden94113152milden
mile66352572mile
miler75733062miler
miles74645072miles
milk105028472milk
mill66541482mill
milo65536102milo
mils66045332mils
milt65455812milt
mim76048422mi_m
mime85736402mime
mimed105622732mimed
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
mina65136922mina
mind75434382mind
mined85333352mined
miner76933542miner
mines75651952mines
mini65634562mini
mink106636532mink
minny104518662minny
mint66758062mint
minx137723352minx
mips85534082mips
mir57046772mi_r
mire66748232mire
mired85729222mired
mires75640882mires
mirex146816622mirex
miri66730372miri
mirin75023152mirin
mirk106729502mirk
mirs66940572mirs
miry96326752miry
mis58162622mi_s
mise66043582mise
miser75430402miser
mises74740562mises
miso67229902miso
mispen10312172mispen
miss65339422miss
mist66154532mist
mite66249412mite
miter75734792miter
mites75141802mites
mitt66145492mitt
mitten83914092mitten
mity95528212mity
mix126138182mi_x
mixed155717252mixed
mixer145017642mixer
mixes147224402mixes
mixt136831922mixt
mizens174610252mizens
mizzen16447952mizzen
moan65832022moan
mon57561582m_on
moon67140812moon
morn66237562morn
mown95424442mown
mun56143862m_un
muon65722732muon
nine45842172nine
omen66828182omen
open66427002open
oven76624142oven
oxen116218592oxen
peen65938082peen
pein65834942pein
pen56558842_pen
pian66136092pian
pie55457402pie_
pied75035362pied
pier66035292pier
pies66949602pies
pin57066722pi_n
pine67755712pine
pion67235292pion
pirn67128372pirn
rein46040892rein
riel46432382riel
rin36663182ri_n
ripen75619262ripen
risen54621882risen
riven85121622riven
seen46943122seen
sen36058522_sen
sign55523052sign
sin36265892si_n
sine46560622sine
siren54525822siren
teen45938202teen
ten35856112_ten
then78429692then
tie36557532tie_
tied55535212tied
tier44936142tier
ties45248312ties
tin36362172ti_n
tine45855132tine
vein75625752vein
vie65447632vie_
vied86328632vied
vier75428152vier
vies75238622vies
view105917672view
vimen104114752vimen
vine75643682vine
vixen153010022vixen
ween75835462ween
wen66249602_wen
when105723042when
widen94717972widen
win66456292wi_n
wine74953422wine
wizen175813862wizen
wren78221682wren
yen66847382_yen
yin67648732yi_n
zein135620602zein
zin125643772zi_n
zine137036152zine

Search took 4 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.580308087.9
2DLD Change Limit298722582.23313377.5
3Display Results2582580.280921.4
 (SQL Overall)1786912583.09357772.7
 
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.