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

175 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
milliped133738(None) 
filliped1435221filliped
milleped1335171milleped
millipede1444221millipede
millipeds1444701millipeds
gillied95512312gilli_ed
maxilliped2251552maxilliped
milled94326172mill__ed
millepede1442982millepede
millepeds1443222millepeds
milliard1147032milliard
millier93716702milli_er
millime112511402millime_
millimes122411372millimes
milline92519112milline_
milliner102811862milliner
millines102718062millines
millipedes1543712millipedes
millirem1245692millirem
misliked15319512misliked
mislived14328782mislived
multiped1337372multiped
willied114611562willi_ed
aliped95414283__aliped
allied74217153_alli_ed
bellied104314073belli_ed
billed94224903bill__ed
billeted1137643billeted
billiard1145873billiard
billie85019173billi_e_
billies93923503billi_es
billowed14137063billowed
bollixed1834483bollixed
bullied104514813bulli_ed
callipee1237733callipee
calliper1247513calliper
cheliped1635043cheliped
cirriped1344183cirriped
collided12309803collided
collied103316673colli_ed
cullied104012353culli_ed
dallied93713613dalli_ed
dilled84122223dill__ed
dillies84122163dilli_es
disliked14288553disliked
dollied93811143dolli_ed
dolloped1234983dolloped
filled104922263fill__ed
filleted1236603filleted
fillies103420253filli_es
fillip11268953fillip__
fillips12298133fillip_s
fissiped1444153fissiped
gallied94115003galli_ed
galloped12107153galloped
gilled84521633gill__ed
gillie74816943gilli_e_
gillies84120963gilli_es
gullied93812063gulli_ed
hilled104022223hill__ed
hillier103413963hilli_er
hilloaed12136923hilloaed
hilloed113211293hill_oed
illite63414923_illite_
illites72415013_illites
illuded9305763_illuded
illumed10285863_illumed
implied1238623impli_ed
jellied15419223jelli_ed
jollied15349273jolli_ed
killed113918773kill__ed
killie104114893killi_e_
killies113318113killi_es
lilied73913213li_li_ed
lilliput1044193lilliput
lolloped1134463lolloped
mainlined1254353mainlined
malled94626113mall__ed
maxillipeds235833maxillipeds
melled95023023mell__ed
mellowed14166923mellowed
midlife13248303midlife_
midlifer14215793midlifer
midline102315103midline_
midlines112613333midlines
midlives14287463midlives
midsized2144733midsized
midwifed18233933midwifed
midwived18263553midwived
milded104416153mi_l_ded
mildened1235773mildened
mildewed1543763mildewed
milieu8314113mi_li_eu
milked134612573mi_l_ked
milkier133411163milki_er
milkshed1842943milkshed
milkweed1843353milkweed
millage103112753millage_
millages113212903millages
mille75029133mill__e_
millepedes1552733millepedes
miller84625413mill__er
milles84526563mill__es
millet84030743mill__et
milliards1246193milliards
milliare1039153milliare
milliares1149403milliares
milliary1346853milliary
millibar1275353millibar
millieme12276803millieme
milliemes13255843milliemes
milliers102611903milliers
milligal1145703milligal
millilux1742933millilux
millimho1543473millimho
milliners11289953milliners
millinery14336103millinery
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
million91813143milli_on
millions101712433millions
millirems1344323millirems
millpond1344143millpond
milted93919943mi_l_ted
miltier93214963milti_er
misaimed1338093misaimed
misallied1246543misalli_ed
miscited13310423miscited
misfiled14278653misfiled
misfired14238543misfired
misled94719313misl__ed
mislie83219153misli_e_
mislies92922283misli_es
mislike132914833mislike_
misliker14319573misliker
mislikes143311833mislikes
mislive122812693mislive_
mislives132912153mislives
mistimed1339123mistimed
mistyped1685173mistyped
mollie83517103molli_e_
mollies93420233molli_es
mollified1545653mollified
mulled94721553mull__ed
mullioned1245733mullioned
mullite9313013mullite_
mullites10411643mullites
multipede1445963multipede
multipeds1445663multipeds
nilled73919453nill__ed
pillaged12298093pillaged
pillared11228093pillared
pilled94222753pill__ed
pillowed14156383pillowed
pinniped1343853pinniped
rallied83514083ralli_ed
rilled74525653rill__ed
sallied83316953salli_ed
sillier74017593silli_er
sillies73425083silli_es
sliped95417063__sliped
sullied83714483sulli_ed
taliped1078203_taliped
tallied83314753talli_ed
tilled74722953till__ed
tillered937443tillered
tillite7313563tillite_
tillites8312833tillites
vilipend1442523vi_lipend
walloped14146833walloped
willed104722453will__ed
willie94116453willi_e_
willies103920153willi_es
willowed15156763willowed

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621757.62319173.8
3Display Results1751750.0632777.8
 (SQL Overall)1786911758.10922036.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.