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

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

87 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
menstruating155386(None) 
menstruation1455222menstruation
menstruations1585052menstruations
constructing1746753constructing
denitrating13128333denitr_ating
destructing1546113de_structing
entreating11811553_en_treating
entrusting11126183_en_trusting
estreating11710363_e_streating
instructing1446293_instructing
menstruate1244413menstruat__e
menstruated1473743menstruat_ed
menstruates1343983menstruat_es
mistreating1449283m_istreating
mistrusting1465923m_istrusting
penetrating1447663penetr_ating
aestivating1545804ae_stivating
castrating1349774_castr_ating
consternating1654974consternating
constipating1775394constipating
constricting1747024constricting
construing1347444constru__ing
deconstructing20113904deconstructing
demonstrating17104764demonstr_ating
denervating1645924den_ervating
denigrating14146924denigr_ating
distrusting1386504_distrusting
elutriating1245074_elutriating
encrusting13125294_en_crusting
enervating1488434_en_ervating
estating92614994_e_st__ating
estimating1348884_e_stimating
estivating1447634_e_stivating
estraying1338294_e_str_aying
eventuating1543254even_t_uating
festinating1547374fe_stinating
frustrating1544264frustr_ating
gastrulating1483004_gastrulating
generating12310394gen_er_ating
gestating11229984ge_st__ating
insinuating1244534_insinuating
instating10812214_inst__ating
instigating1347154_instigating
intreating11614014_in_treating
intrusting11128174_in_trusting
lustrating1147784_lustr_ating
mainstreaming1861294mainstreaming
maltreating1455514m_altreating
masticating1647834m_asticating
masturbating1772674m_asturbating
maturating13108574m__aturating
meditating1448124medit__ating
meliorating1446564melior_ating
menstrua1044024menstrua____
menstrual1144354menstrua___l
menstrually1652864menstrua_lly
mensuration1346494mensur_ation
mensurations1445714mensur_ations
mercurating1645954mercur_ating
metricating1647364me__tricating
micturating1644884m_icturating
miscreating1648494m_iscreating
misrating121014854m_is_r_ating
misstating13129314misst__ating
mistracing1569604m_istr_acing
mistrysting1774314m_istrysting
nitrating10312674__nitr_ating
obstructing1644574_obstructing
prostrating1449394prostr_ating
punctuating1643104punct_uating
reconstructing1974434reconstructing
reestimating1545934reestimating
reinstating1248114reinst__ating
remonstrating1695554remonstr_ating
repatriating1545454repatriating
resituating1247544re_situating
restating102319414re_st__ating
restricting1449304re_stricting
retreating111414774re__treating
sensating1039254sens___ating
striating10914194___striating
strunting1037874___strunting
strutting1037004___strutting
unstating10711214_unst__ating
untrusting1186004_un_trusting
venerating14410054ven_er_ating
ventilating1546344ven_tilating

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 Filter1786911247900.406440125.6
2DLD Change Limit124790877.68616236.0
3Display Results87870.0461891.3
 (SQL Overall)178691878.13821957.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.