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 “maturated” 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
maturated124916(None) 
maturate10312621maturate_
maturates11311761maturates
saturated1038991saturated
aurated83817792_a_urated
macerated142010522macerated
maculated142411502maculated
masturbated1652802masturbated
matured10310042matur__ed
micturated1584992micturated
obturated1245952obturated
saturate8312812saturate_
saturater947902saturater
saturates9811602saturates
acerated113113983_acerated
actuated1138743actu_ated
adulated1039753_adulated
aerated85322373_a_erated
ambulated1457133ambulated
amputated1444463amputated
attracted1246073_attracted
attrited947373_attrited
aurate64426473_a_urate_
canulated12310673canulated
castrated1239513castrated
catenated1238913catenated
caudated1238063ca_udated
citrated112712253cit_rated
curated104717583__curated
depurated1338183depurated
extubated1944133extubated
fabulated1546323fabulated
gratulated1255733gratulated
indurated1139013indurated
intubated1246453intubated
iterated91213823_iterated
jaculated19289053jaculated
lacerated122210683lacerated
lateraled1047463lateraled
laureated1096153la_ureated
macerate122314073macerate_
macerater13259523macerater
macerates132113573macerates
maculate122815623maculate_
maculates132013723maculates
maltreated13125143maltreated
mandated12310293ma_ndated
manducated1644563manducated
manured1039473manur__ed
marinated122513173marinated
marted94425213ma__r_ted
masticated1548233masticated
masturbate1443473masturbate_
masturbates1553423masturbates
matted94521413mat___ted
maturating13108573maturating
maturation1249513maturation
mature8313473matur__e_
maturer938983matur__er
matures9314313matur__es
maturities1248453maturities
maturity1367443maturit_y
mercurated1545393mercurated
micturate1366643micturate_
micturates1456093micturates
migrated121110513m_igrated
misrated111315383m_israted
mitigated1347083mitigated
moderated1388143moderated
modulated1336713modulated
motivated1545963motivated
muraled10410833m__uraled
muriated1139793m__uriated
mutated102712253m__utated
mutilated1239453mutilated
narrated9310323na_rrated
natured838963natur__ed
nitrated92213153nit_rated
obturate1077773obturate_
obturates1157003obturates
outrated92219313out_rated
patinated123911413patinated
patriated1238533patriated
satiated9311603sat_iated
saturaters1045563saturaters
saturator946613saturator
situated938033situ_ated
tabulated1237303tabulated
tartrated1096643tartrated
titrated92611683tit_rated
triturated1145073triturated
unsaturated1244923unsaturated
valuated12239203valu_ated

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 Limit148641937.11020905.9
3Display Results93930.0462021.7
 (SQL Overall)178691937.57923577.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.