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

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
matriculated175461(None) 
matriculate1546191matriculate_
matriculates1655471matriculates
articulated1447622_articulated
articulate12410243_articulate_
articulates1349043_articulates
auriculate1246493_auriculate_
fasciculated2053053fasciculated
machicolated2251803machicolated
maculated142411503ma___culated
manipulated1643963ma_nipulated
matriculant1553803matricula_nt
matriculants1652723matriculants
matriculating1863983matriculating
matriculation17125383matriculation
metricated1547303metric__ated
misarticulated1973003misarticulated
nonmatriculated2071293nonmatriculated
particulate1548313particulate_
particulates1647363particulates
rearticulated1654153rearticulated
reticulated14127783ret_iculated
stridulated1353893_stridulated
tribulated1345823__tribulated
unarticulated1653843unarticulated
aciculate132510804_a_ciculate_
acidulated14195154_a_cidulated
apiculate13279884_a_piculate_
arcuated1138804_a_r_cu_ated
articulately1754004_articulately
articulator1376654_articulator
auriculae1145164_auricula_e_
calculated1577804ca__lculated
capitulated1644154ca_pitulated
circulated1588064_cir_culated
denticulated1654394denticulated
disarticulated1873324disarticulated
emasculated1644534ema__sculated
extricated2067084extric__ated
fabricated1845404fabric__ated
fasciculate1854004fasciculate_
gastrulated1352974gastr__ulated
geniculated1544644_geniculated
gesticulated1654544gesticulated
inarticulate1454564inarticulate_
inarticulates1554194inarticulates
jaculated19289054ja___culated
maculate122815624ma___culate_
maculates132013724ma___culates
mammillated1551714mammi_llated
mandibulate1652844mandibulate_
manipulate1445164ma_nipulate_
manipulates1544634ma_nipulates
marinated122513174ma_ri__nated
masticated1548234mastic__ated
matriculations18144784matriculations
maturated1249164mat___urated
mercurated1545394m_er_curated
metricate1349924metric__ate_
metricates1449124metric__ates
misarticulate1793334misarticulate_
misarticulates1883194misarticulates
muricated1448244m_uric__ated
mutilated1239454mut_i__lated
operculated1645154oper_culated
paniculate1447214pa_niculate_
participated1953704participated
patriated1238534patri___ated
patriciate1446324patric_iate_
patriciates1545324patric_iates
rearticulate1455044rearticulate_
rearticulates1554624rearticulates
recirculated1753954recirculated
reticulate12219784ret_iculate_
reticulates13148874ret_iculates
sacculated1546624sa__cculated
stimulated1346364_st_imulated
stipulated1345594_st_ipulated
stridulate1144994_stridulate_
stridulates1254544_stridulates
tribulate1148084__tribulate_
tribulates1247204__tribulates
triturated1145074__triturated
uncirculated1753244uncirculated
variolated1445404va_ri_olated
vaticinated1753434vat_icinated
vermiculated2064514vermiculated
vesiculated1745554_vesiculated

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 Limit124790887.78316033.7
3Display Results88880.0461913.0
 (SQL Overall)178691888.23521699.0
 
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.