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 “milneb” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

431 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
milneb109595(None) 
milnebs11113791milnebs
kilned11368392kilned
milded104416152milded
milden94113152milden
milder93818452milder
mildew12319042mildew
mile66352572mil_e_
miler75733062mil_er
miles74645072mil_es
milieu8314112milieu
milked134612572milked
milker124814322milker
mille75029132mille_
milled94326172milled
miller84625412miller
milles84526562milles
millet84030742millet
milted93919942milted
milter84921232milter
mine67256172mi_ne_
mined85333352mi_ned
miner76933542mi_ner
mines75651952mi_nes
zineb165614142zi_neb
ailed66240283ail_ed
aline57243153aline_
alined75221403alined
aliner65621983aliner
alines65735223alines
amine75835383ami_ne_
amines84727983ami_nes
bile66147183bil_e_
biles75542143bil_es
bilge87618913bilge_
bilged105513183bilged
bilges94915633bilges
bilked134012943bilked
bilker124913443bilker
billed94224903billed
biller84923483biller
billet86029723billet
bine66650863bi_ne_
biner75930693bi_ner
bines76946793bi_nes
binned94414543binned
bleb85425223_bl_eb
celeb9314873cel_eb
cine66242943ci_ne_
cines75239683ci_nes
cline76428533cline_
clines84926043clines
diene65720133diene_
dienes75719903dienes
dilled84122223dilled
dine55555333di_ne_
dined76431993di_ned
diner65632903di_ner
dines66449153di_nes
dinned84317613dinned
dinner74217163dinner
dipnet91317473dipnet
file75446643fil_e_
filed95331903fil_ed
filer85433003fil_er
files85441273fil_es
filet85540163fil_et
fille84327403fille_
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
filmed124610363filmed
filmer114112403filmer
filter94517633filter
fine75147953fi_ne_
fined94930503fi_ned
finer85431563fi_ner
fines86644263fi_nes
finned104114603finned
gilded94413223gilded
gilder84415533gilder
gilled84521633gilled
giller74519733giller
gillnet839733gillnet
ginned83813983ginned
ginner73915823ginner
girned84010513girned
hilled104022223hilled
hiller94421633hiller
hilted104016043hilted
ilea45931463_il_ea
ilex115822033_il_ex
iller54821293_iller
imine75821063imine_
imines84918353imines
inlet53732403_inlet
inned64118423_inned
inner54920633_inner
jilted144111353jilted
jilter133512513jilter
jinnee13411573jinnee
jitney16304623jitney
kidney1434763kidney
killed113918773killed
killer104917953killer
kiln85620983kiln__
kilns95112983kiln_s
kilted113613833kilted
kilter103714343kilter
kine85643433ki_ne_
kines95039133ki_nes
kirned11408623kirned
liane54720663liane_
lianes63819323lianes
lilied73913213lilied
lilies63021413lilies
lilted73715373lilted
limned94811473limned
limner84112873limner
line46965573li_ne_
lined64934643li_ned
linen55728723li_nen
liner55938923li_ner
lines57054573li_nes
liney87029633li_ney
linnet6419423linnet
magnet9320663magnet
maile75232223mail_e_
mailed95326753mail_ed
mailer84724183mail_er
mailes84329113mail_es
mailmen1137273mailmen
male66052303mal_e_
males75049793mal_es
malfed12369763malfed
maline84529083maline_
malines93625603malines
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
malted94819863malted
mane65052033m_ane_
maned86634103m_aned
manes76648963m_anes
manned94418643manned
manner84020513manner
meaner84617843meaner
melded104714713melded
melder93915813melder
melee73729103mel_ee
melees83618083melees
melena81110473melena
melled95023023melled
melted94219063melted
melter83520113melter
mesne75116293mesne_
mesnes85216213mesnes
mib76946123mi___b
mice87442233mi_ce_
miche126219243miche_
miched143913393miched
miches134320733miches
mickey174211853mickey
midden104112853midden
midge95016553midge_
midges103516483midges
midget103718453midget
midleg1038553midleg
midline102315103midline_
midlines112613333midlines
midrib1138243midrib
mien65028363mi__en
miens76118303mien_s
miffed15398713miffed
mignon937953mignon
mihrab1335523mihrab
mike105535293mi_ke_
miked125020453mi_ked
mikes115129893mi_kes
mikveh18132543mikveh
mil55752113mil___
miladi938883miladi
milady1236613milady
milage93414123milage
milages103114403milages
milch124413373mil_ch
mild75330853mil__d
mildened1235773mildened
mildens10339933mildens
mildest102812063mildest
mildews13365883mildews
mildewy16353533mildewy
mildly12318243mildly
mildness1136523mildness
milds86422053mil_ds
milers84625163milers
milia72719573mil_ia
milieus939803milieus
milieux1643783milieux
milium104712683milium
milk105028473mil__k
milkers134411613milkers
milkier133411163milkier
milkmen1565213milkmen
milks115020583mil_ks
milky144014443mil_ky
mill66541483mil__l
millers93621343millers
millets94216843millets
millier93716703millier
milline92519113milline_
milliner102811863milliner
millines102718063millines
mills75435053mil_ls
milo65536103mil__o
milord999573milord
milos75428013mil_os
milpa92111403mil_pa
milpas101710273milpas
milreis937323milreis
mils66045333mil__s
milt65455813mil__t
milters93619093milters
miltier93214963miltier
milts75430713mil_ts
milty104720073mil_ty
mime85736403mi_me_
mimed105622733mi_med
mimeo96018683mi_meo
mimer94825763mi_mer
mimes95732023mi_mes
mina65136923mi_n_a
minae75627723mi_nae
minas75434113mi_nas
mince95325233mi_nce
minced114114913minced
mincer104017363mincer
minces104420803minces
mincy125817413mi_ncy
mind75434383mi_n_d
minded103817833minded
minder94822503minder
minds85427123mi_nds
miners84126633mi_ners
mingy115520183mi_ngy
mini65634563mi_n_i
minim97321603mi_nim
minis75432993mi_nis
mink106636533mi_n_k
minke115421763mi_nke
minkes124618783minkes
minks115829273mi_nks
minnies93617363minnies
minnow1135583minnow
minny104518663mi_nny
minor74920063mi_nor
mint66758063mi_n_t
minted94220583minted
minter84425103minter
mints76834043mi_nts
minty106323903mi_nty
minuet82621033minuet
minus75223933mi_nus
minx137723353mi_n_x
minxes154612983minxes
mioses84318853mioses
mire66748233mi_re_
mired85729223mi_red
mires75640883mi_res
mirex146816623mi_rex
mirier83918363mirier
mirker123712693mirker
mise66043583mi_se_
miser75430403mi_ser
mises74740563mi_ses
misfed124113023misfed
misknew1633883misknew
misled94719313misled
mislie83219153mislie_
mislies92922283mislies
mismet103722373mismet
mispen10312173mispen
missed94423603missed
missel85216523missel
misses85130873misses
misset85028153misset
misted93625823misted
mister84728563mister
mite66249413mi_te_
miter75734793mi_ter
mites75141803mi_tes
mither114218563mither
mitier83620673mitier
mitre75522423mitre_
mitred94414343mitred
mitres83922073mitres
mitten83914093mitten
mixed155717253mi_xed
mixer145017643mi_xer
mixes147224403mi_xes
mizen164815273mi_zen
mizens174610253mizens
mizzen16447953mizzen
moaned94514173moaned
moaner84415113moaner
moiled94318863moil_ed
moiler84017263moil_er
molded104414083molded
molder93819273molder
mole66251833mol_e_
moles74747923mol_es
molies84429513molies
moline84422033moline_
molted94217473molted
molten83311813molten
molter84119423molter
money104826843m_oney
mooned94216643mooned
mooner85317833mooner
mule65236973mul_e_
muled85824433mul_ed
mules75034293mul_es
muley104819283mul_ey
mulled94721553mulled
mullen83714763mullen
muller83820353muller
mullet84126823mullet
mulley114013453mulley
neb57238623___neb
nilled73919453nilled
nine45842173ni_ne_
nines55937343ni_nes
oiled64429473oil_ed
oiler54628283oil_er
oilier64417233oilier
oilmen848313oilmen
pile65649693pil_e_
pilea75123953pil_ea
piled85232993pil_ed
pilei74021783pil_ei
piles74742613pil_es
pilfer1139163pilfer
pilled94222753pilled
pilsner935343pilsner
pine67755713pi_ne_
pined85935323pi_ned
pines76048863pi_nes
piney105727503pi_ney
pinned94818383pinned
pinner84521503pinner
pleb86123813_pl_eb
rile45650533ril_e_
riled65833253ril_ed
riles55343643ril_es
riley84420583ril_ey
rille55728733rille_
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
signed83413753signed
signee73617233signee
signer74015633signer
signet73621153signet
silane62718053silane_
silanes72517163silanes
sileni63312143sileni
silent64125843silent
silex123417413sil_ex
silked114314813silked
silken104410853silken
siller64026063siller
siloed74615303siloed
silted74020013silted
silver93815813silver
silvex16336723silvex
simnel857023simnel
sine46560623si_ne_
sines55954823si_nes
sinew84718923si_new
sinned73818413sinned
sinner64320603sinner
smile74823923smil_e_
smiled93716433smil_ed
smiler83916683smil_er
smiles84522293smil_es
smiley114012303smil_ey
telnet6518833telnet
tilde65017343tilde_
tildes74513963tildes
tile45451443til_e_
tiled64832943til_ed
tiler56131023til_er
tiles55542103til_es
tilled74722953tilled
tiller64222543tiller
tilted74616863tilted
tilter63417693tilter
tine45855133ti_ne_
tinea54923163ti_nea
tined65434533ti_ned
tines54848423ti_nes
tinned74317533tinned
tinner64119963tinner
vile76139803vil_e_
viler86324163vil_er
vine75643683vi_ne_
vined95626153vi_ned
vines85137643vi_nes
wiener94513543wiener
wilded113714503wilded
wilder103616473wilder
wile75944373wil_e_
wiled95231553wil_ed
wiles85437873wil_es
wilier93217073wilier
willed104722453willed
willer94021063willer
willet95124833willet
wilted103915713wilted
wine74953423wi_ne_
wined94434183wi_ned
wines85546863wi_nes
winey115325433wi_ney
winned104017013winned
winner94219933winner
witney12356843witney
zine137036153zi_ne_
zinebs17606803zi_nebs
zines145232653zi_nes

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127164314.90622975.1
3Display Results4314310.1403078.6
 (SQL Overall)1786914315.43932853.6
 
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.