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

125 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
measurer103595(None) 
measure939031measure_
measured1136461measured
measurers1144881measurers
measures1038911measures
censurer10228132censurer
ensurer73011902_ensurer
manurer938582m_anurer
maturer938982m_aturer
measlier1036012measlier
treasurer944252treasurer
admeasure1252183admeasure_
admeasured1451733admeasured
admeasures1352433admeasures
assurer767793_assurer
bearer85323913bea__rer
censure92310603censure_
censured11248913censured
censurers11256073censurers
censures102211623censures
dearer74822803dea__rer
demurer1037873de_murer
desirer8310783de_sirer
devourer1235063devourer
eagerer8248823_eagerer
easier64218463_eas_ier
easter65027983_eas_ter
endurer83210363_endurer
ensure63416003_ensure_
ensured83512943_ensured
ensurers8279373_ensurers
ensures73315903_ensures
erasure736943erasure_
erasures837213erasures
fearer94820183fea__rer
feaster10812983feas_ter
feature1039853feature_
featured1237683featured
features11310333features
gesturer935983gesturer
hearer94323643hea__rer
insurer73312803_insurer
leaguer835793leagu_er
leaser65322673leas__er
lecturer10136033lecturer
leisure736693leisure_
leisured934763leisured
leisures836683leisures
manure8313653m_anure_
manured1039473m_anured
manurers1037593m_anurers
manures9313353m_anures
marrer83716673m_a_rrer
maser75029973m_as__er
masher114123203m_as_her
masker124416103m_as_ker
masquer18266463m_asquer
massier93615223m_assier
master84831343m_as_ter
mature8313473m_ature_
matured10310043m_atured
maturers1037383m_aturers
matures9314313m_atures
mauger93813483m_a_uger
mauler84416713m_a_uler
meager94515203mea__ger
meagre9349323mea_gre_
mealier93015903mea_lier
meander1049973mea_nder
meanderer1244733meanderer
meaner84617843mea__ner
measle83513223meas_le_
measled10339303meas_led
measles92412753meas_les
measuredly1652173measuredly
measuring1236123measuring
meatier93214613mea_tier
meatuses1038203meatuses
meister93114163meis_ter
mensural1046233mensural
merer75126233me___rer
meshier123410853me_shier
messier93412923me_ssier
misuser93210443m_isuser
murmurer1242873murmurer
nearer64618893nea__rer
pasturer1037523_pasturer
peasouper1382193peasouper
perjurer17285903perjurer
pleasure1045543pleasure_
pleasured1244193pleasured
pleasures1145573pleasures
rasure6311423_rasure_
rasures7312013_rasures
rearer64928913rea__rer
reasoner849343reasoner
reassure847343reassure_
reassured1046103reassured
reassures937223reassures
reinsurer945603reinsurer
remeasure1143943remeasure_
remeasured1343053remeasured
remeasures1243853remeasures
resumer9410113re_sumer
seafarer1144843seafarer
searer65432023sea__rer
seasoner857693seasoner
securer958253se_curer
seisure738193seisure_
seisures838273seisures
smearer94110403smea__rer
surer54833103___surer
tearer64822903tea__rer
teaseler8176583teaseler
teaser65421523teas__er
treasure846753treasure_
treasured1044983treasured
treasurers1043203treasurers
treasures946633treasures
unmeasured1343303unmeasured
usurer638103__usurer
venturer1137243venturer
wearer94319403wea__rer
yeasayer1442353yeasayer
yeastier1135393yeastier

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.423422437.4
2DLD Change Limit1461621256.83021400.0
3Display Results1251250.0602083.3
 (SQL Overall)1786911257.31324434.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.