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

161 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
milliners1128995(None) 
milliers102611901milli_ers
milliner102811861milliner_
millinery14336101millinery
millines102718061milline_s
airliners945982airliners
hilliness1248922hilliness
mainliners1244002mainliners
midlifers15254932midlifers
midlines112613332midline_s
milkiness1536522milkiness
millers93621342mill__ers
milliares1149402milliares
millibars1365562millibars
millier93716702milli_er_
millimes122411372millime_s
milline92519112milline__
millineries1355482millineries
millings113712582millin_gs
millipeds1444702millipeds
millirems1344322millirems
mislikers15317062mislikers
silliness9510362silliness
airliner836953airliner_
airlines8312793airline_s
aliners74717723__aliners
billers94720833bill__ers
billeters1136873billeters
billies93923503billi_e_s
billings113412633billin_gs
byliners1334753_byliners
callipers1356493callipers
chilliness1555313chilliness
colliders12298073colliders
colliers103613583colli_ers
dalliers93610613dalli_ers
decliners12358613decliners
dillies84122163dilli_e_s
dislikers14286423dislikers
diviners12308353di_viners
eloiners8128153_eloiners
eyeliners1264063eyeliners
fillers104320213fill__ers
fillies103420253filli_e_s
fillings122910503fillin_gs
fillisters1343873fillisters
filminess1435983filminess
gillers84216903gill__ers
gillies84120963gilli_e_s
gillnets934733gill_nets
hillers103718733hill__ers
hillier103413963hilli_er_
hiplines13310593hipline_s
illites72415013_illite_s
illness736473_ill_ness
imaginers1243693imaginers
incliners1146333incliners
inliers73110743_inli_ers
jetliners1644183jetliners
jolliers15357433jolli_ers
jolliness1636213jolliness
killdeers1462453killdeers
killers114215583kill__ers
killies113318113killi_e_s
killings133710483killin_gs
kiloliters1442933kiloliters
liners65428853___liners
mainliner1144673mainliner_
mainlines1138513mainline_s
maligners12104783maligners
malines93625603m_aline_s
malingers1285853m_alingers
mallings113413093mallin_gs
maltiness112910573maltiness
manliness111310123manliness
mariners103113863m_ariners
marlines103818713marline_s
mealiness11310063mealiness
midlifer14215793midlifer_
midline102315103midline__
midlives14287463midlive_s
midwinters1642483midwinters
miffiness1734523miffiness
mildness1136523mi_ldness
milers84625163mi_l__ers
milieus939803mi_li_eus
milkers134411613mi_l_kers
milkier133411163milki_er_
millages113212903millage_s
millenary1444583millenary
millepeds1443223millepeds
miller84625413mill__er_
milles84526563mill__e_s
millets94216843mill__ets
milliard1147033milli_ard
milliards1246193milliards
milliare1039153milli_are
milliary1346853milli_ary
millibar1275353millibar_
millieme12276803milli_eme
milliemes13255843milliemes
milligals1245033milligals
millihenry1851923millihenry
millihenrys1951153millihenrys
milliliters1353043milliliters
millime112511403millime__
millimeters1544153millimeters
millimhos1642893millimhos
milling103223683millin__g
milliohms1643673milliohms
millions101712433milli_ons
millionths1543243millionths
milliped1337383millipe_d
millipede1444223millipede
millipedes1543713millipedes
millirem1245693millire_m
milnebs11113793mi_l_nebs
milters93619093mi_l_ters
miltier93214963milti_er_
miners84126633m___iners
minivers1337483mi_nivers
miriness10310463mi_riness
misinfers1445483mi_sinfers
misinters1138183mi_sinters
mislayers1445943mislayers
mislies92922283misli_e_s
misliker14319573misliker_
mislikes143311833mislike_s
mislives132912153mislive_s
missioners1245853missioners
mistiness111911633mistiness
moldiness12227053moldiness
mollies93420233molli_e_s
mollifiers1543993mollifiers
mullers93217303mull__ers
mullites10411643mullite_s
myelines1337123myeline_s
oiliness8311563oi_liness
outliners9228363outliners
pillagers12276923pillagers
pilseners1144943pilseners
pilsners1035533pi_lsners
ralliers84010833ralli_ers
recliners11279113recliners
redliners10267853redliners
salliers83613343salli_ers
sideliners11125133sideliners
silkiness1337253silkiness
sillers73822103sill__ers
sillier74017593silli_er_
sillies73425083silli_e_s
talliers83711373talli_ers
tillers73418743till__ers
tillites8312833tillite_s
villagers13296153villagers
villainess1343853villainess
wiliness1139113wi_liness
willers103517913will__ers
willies103920153willi_e_s
willinger1343723willinger_
willowers15166693willowers

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411617.07621006.4
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.56223630.1
 
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.