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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
measured113646(None) 
measure939031measure_
measurer1035951measurer
measures1038911measures
admeasured1451732admeasured
censured11248912censured
ensured83512942_ensured
featured1237682featured
leisured934762leisured
manured1039472m_anured
matured10310032m_atured
measled10339302meas_led
measuredly1652172measuredly
measurers1144882measurers
pleasured1244192pleasured
reassured1046102reassured
remeasured1343052remeasured
treasured1044982treasured
unmeasured1343302unmeasured
admeasure1252183admeasure_
admeasures1352433admeasures
assured858373_assured
beavered1437503beavered
ceased94920783ceas__ed
censored11197953censored
censure92310603censure_
censurer10228133censurer
censures102211623censures
censused11184973censused
closured11266353closured
deaired9411533dea_ired
deashed123411303deas_hed
denatured1146023denatured
desired9311983de_sired
detoured1036513detoured
devoured1335723devoured
eared65139503_ea__red
eased65430403_eas__ed
easeled8159853_easeled
endured93611213_endured
ensued73610483_ensu_ed
ensure63416003_ensure_
ensurer73011903_ensurer
ensures73315903_ensures
enured73315333_e_nured
erasure736943erasure_
erasures837213erasures
feared106320433fea__red
feased105718713feas__ed
feasted11310843feas_ted
feature1039853feature_
features11310333features
fissured1235183fissured
geared85317743gea__red
gestured1036993gestured
insured83714253_insured
leagued935463leagu_ed
leaguered1143223leaguered
leased74722883leas__ed
leashed113211163leas_hed
lectured11127223lectured
leisure736693leisure_
leisures836683leisures
maculed123510053m_aculed
majored1735853m_ajored
manure8313653m_anure_
manurer938583m_anurer
manures9313353m_anures
marred95421043m_a_rred
mashed125325043m_as_hed
masked134316523m_as_ked
masoned1039803m_asoned
massed94421323m_as_sed
masted94025803m_as_ted
mastered112614003m_astered
mature8313463m_ature_
maturer938973m_aturer
matures9314303m_atures
mauled94817823m_a_uled
meagre9349323mea_gre_
meandered1346143meandered
measle83513223meas_le_
measles92412753meas_les
measlier1036013measlier
measuring1236123measuring
meated94222403mea__ted
meatuses1038203meatuses
membered1535903membered
mensed93916543mens__ed
mensural1046223mensural
mentored1138003mentored
meoued9118533me_ou_ed
meshed124415933me_s_hed
messaged1235543messaged
messed95018183me_s_sed
metered103514013me_tered
metred95315143me__tred
miaoued1034583miaou_ed
miauled1036663mia_uled
misused104111283m_isused
mured85726703m___ured
murmured1343113murmured
natured838963_natured
neared75119803nea__red
pastured1138233_pastured
perdured12287403perdured
perjured18286273perjured
pleasure1045543pleasure_
pleasures1145573pleasures
preassured1344533preassured
premeasured1652323premeasured
pressured1237333pressured
rasure6311423_rasure_
rasures7312013_rasures
reared75930013rea__red
reasoned9410733reasoned
reassumed1243793reassumed
reassure847343reassure_
reassures937223reassures
reinsured1036983reinsured
remeasure1143943remeasure_
remeasures1243853remeasures
renatured1047283renatured
repoured1139563repoured
resumed10310623re_sumed
resurged1038623re_surged
seared75232843sea__red
seasoned948113seasoned
secured1059723se_cured
seisure738193seisure_
seisures838273seisures
smeared104510623smea__red
teared75722153tea__red
teased74721153teas__ed
teaseled9186793teaseled
tenured838363te_nured
textured1695483textured
tonsured976383tonsured
treasure846753treasure_
treasurer944253treasurer
treasures946633treasures
unassured1084353unassured
unensured1044943unensured
velured1136683ve_lured
ventured1238273ventured
verdured13255763verdured
vestured1237463vestured
weaseled12175143weaseled
yeasted1138503yeas_ted

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621498.00018270.3
3Display Results1491490.0463239.1
 (SQL Overall)1786911498.20221786.3
 
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.