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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
millieme1227680(None) 
milliemes13255841milliemes
millime112511401milli_me
milliare1039152milliare
millier93716702millie_r
milliers102611902milliers
millimes122411372millimes
milline92519112milli_ne
millipede1444222millipede
millirem1245692millirem_
millirems1344322millirems
billie85019173billi__e
billies93923503billie_s
dillies84122163dillie_s
fillies103420253fillie_s
gillie74816943gilli__e
gillied95512313gillie_d
gillies84120963gillie_s
hillier103413963hillie_r
hilliest113914113hilliest
illite63414923_illi_te
illume8298223_ill_ume
killdee1266213killde_e
killie104114893killi__e
killies113318113killie_s
mallee84525593mall_e_e
midlife13248303midli_fe
midline102315103midli_ne
milieu8314113mi_lie_u
milieus939803mi_lieus
milieux1643783mi_lieux
milium104712683mi_lium_
milkier133411163milkie_r
milkiest142911083milkiest
millable121710133millable
millage103112753mill_age
millcake1644653millcake
milldam1245473milldam_
milldams1344633milldams
mille75029133mill___e
milled94326173mill_e_d
milleped1335173mill_eped
millepede1442983millepede
miller84625413mill_e_r
millers93621343mill_ers
milles84526563mill_e_s
millet84030743mill_e_t
millets94216843mill_ets
milliard1147033milliard
milliares1149403milliares
milliary1346853milliary
millibar1275353millibar
milligal1145703milligal
millilux1742933millilux
millimeter1444543millimeter
millimho1543473millimho
millimole1344343millimole
milliner102811863milliner
milliners11289953milliners
millinery14336103millinery
millines102718063millines
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
milliohms1643673milliohms
million91813143milli_on
millions101712433millions
milliped1337383milliped
millipedes1543713millipedes
millipeds1444703millipeds
millrace1245433millrace
miltier93214963miltie_r
miltiest103015173miltiest
mislie83219153misli__e
mislies92922283mislie_s
mislike132914833misli_ke
mislive122812693misli_ve
mistime11312613misti_me
mollie83517103molli__e
mollies93420233mollie_s
mullite9313013mulli_te
sillier74017593sillie_r
sillies73425083sillie_s
silliest84017103silliest
tillite7313563tilli_te
willie94116453willi__e
willied114611563willie_d
willies103920153willie_s

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162887.00020880.3
3Display Results88880.0302933.3
 (SQL Overall)178691887.20324807.9
 
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.