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

42 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
advertizement2817248(None) 
advertisement19163191advertisement
advertizements29162271advertizements
advertisements20182852advertisements
advertent1356594advert____ent
advertize2245384advertiz__e__
advertized2443794advertiz__e_d
advertizes2344674advertiz__e_s
advertizing25144304advertiz__ing
advisement1645644adv___isement
divertissement2081854divertissement
admeasurement18151335admeasurement
advancement1953165adv__ancement
adverting1437225adverti____ng
advertise1346105adverti__se__
advertised1544095adverti__se_d
advertiser1443615adverti__se_r
advertisers1552545adverti__sers
advertises1445915adverti__se_s
advertising16143615adverti__sing
advisements1754825adv___isements
amercement1645995a_mer__cement
apportionment19102475apportionment
appraisement1873395a_ppraisement
ascertainment1761885ascertainment
averment13311605a_ver____ment
debridement1754175_d_ebridement
defilement1648075_d_e_filement
definement1648065_d_e_finement
derailment1346875_d_erai_lment
derangement1556465_d_erangement
despisement1675895_d_espisement
detriment1249695_d_etri__ment
devotement1646285_devot__ement
divertimenti1863125diverti__menti
divertimento18122975diverti__mento
divertissements21102025divertissements
enticement1489605___enticement
intertwinement1961935intertwinement
overstatement1863005_overstatement
preretirement1762715_preretirement
retirement1259125__re_tirement

Search took 10 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.376475242.0
2DLD Change Limit124790429.07613749.4
3Display Results42420.0331272.7
 (SQL Overall)178691429.48518839.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.