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

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

32 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
admeasurements1917125(None) 
admeasurement18151331admeasurement_
measurements1653192__measurements
remeasurements18141482remeasurements
measurement1554013__measurement_
remeasurement17161683remeasurement_
admeasures1352434admeasur__e__s
appeasements1853144appeas__ements
abasements1446535a__bas__ements
adjournments2251975ad__journments
admeasure1252185admeasur__e___
admeasured1451735admeasur__e__d
admeasuring1551615admeasur__in_g
advancements2052815ad_va_ncements
advertisements20182855advertisements
advertizements29162275advertizements
advisements1754825ad_vis__ements
allurements1353655a___llurements
amassments1444495a_m_as__sments
amazements2345315a_m_a__zements
amercements1755265a_me__rcements
amusements1446235a_m___usements
appeasement1753595appeas__ement_
beleaguerments19131345beleaguerments
debasements1666175_debas__ements
decrements1549385_d_e__crements
denouements1446475_d_enou_ements
denudements1545335_d_e_nudements
easements11410335___eas__ements
immurements1474785_im__murements
measureless1371735__measurele_ss
securements1545495__se_curements

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit95024326.26315172.3
3Display Results32320.033969.7
 (SQL Overall)178691326.65626846.6
 
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.