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

93 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
millirem124569(None) 
millirems1344321millirems
milliare1039152milliare_
milliares1149402milliares
millieme12276802milli_eme
millier93716702milli_er
milliers102611902milliers
milligram1443902milligram
millime112511402millime_
millimes122411372millimes
milline92519112milline_
milliner102811862milliner
millines102718062millines
milliohm1544442milliohm
milliped1337382milliped
billie85019173billi_e_
billies93923503billi_es
dillies84122163dilli_es
fillies103420253filli_es
filliped1435223filliped
gillie74816943gilli_e_
gillied95512313gilli_ed
gillies84120963gilli_es
hillier103413963hilli_er
illite63414923_illite_
illites72415013_illites
killie104114893killi_e_
killies113318113killi_es
midlife13248303midlife_
midlifer14215793midlifer
midline102315103midline_
midlines112613333midlines
midlives14287463midlives
milieu8314113mi_li_eu
milium104712683mi_li_um
milkier133411163milki_er
millage103112753millage_
millages113212903millages
milldam1245473mill_dam
mille75029133mill__e_
milled94326173mill__ed
milleped1335173milleped
miller84625413mill__er
millers93621343miller_s
milles84526563mill__es
millet84030743mill__et
milliard1147033milliard
milliards1246193milliards
milliaries1248243milliaries
milliary1346853milliary
millibar1275353millibar
milliemes13255843milliemes
milligal1145703milligal
milligrams1553523milligrams
millilux1742933millilux
millimho1543473millimho
milliners11289953milliners
millinery14336103millinery
milling103223683milli_ng
millings113712583millings
milliohms1643673milliohms
million91813143milli_on
millions101712433millions
millipede1444223millipede
millipeds1444703millipeds
millrun944183mill_run
millstream1461973millstream
miltier93214963milti_er
misfire12229893misfire_
misfired14238543misfired
misfires132210583misfires
mislie83219153misli_e_
mislies92922283misli_es
mislike132914833mislike_
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislive122812693mislive_
mislived14328783mislived
mislives132912153mislives
mollie83517103molli_e_
mollies93420233molli_es
mullite9313013mullite_
mullites10411643mullites
pillared11228093pillared
sillier74017593silli_er
sillies73425083silli_es
tillered937443tillered
tillite7313563tillite_
tillites8312833tillites
willie94116453willi_e_
willied114611563willi_ed
willies103920153willi_es

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.420425454.8
2DLD Change Limit146162936.91021152.2
3Display Results93930.0303100.0
 (SQL Overall)178691937.36024278.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.