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

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
semiretirements1910116(None) 
semiretirement18101471semiretirement_
retirements1357614____retirements
embrittlements2061605_embrittlements
empressements1962835_empre_ssements
postretirement1881225postretirement_
preretirement1762715_preretirement_
retirement1259125____retirement_
semiretired1452285semiretir__e__d
advertisements20182856adver_tisements
advertizements29162276adver_tizements
belittlements1772066beli__ttlements
bereavements19154206be__re_avements
curettements1652486__curet_tements
debridements1853896de_br__idements
embattlements1952786_em_battlements
embezzlements2762006_em_bezzlements
embitterments19102006_embitter_ments
embracements2055246_embr__acements
embranglements21132536_embranglements
embrittlement1961856_embrittlement_
embroilments1863316_embr_oi_lments
empressement1853266_empre_ssement_
enticements1598166_e___nticements
hereditaments1961486he__reditaments
misrepresents17142206__misre_presents
misstatements17122906__misstatements
overrefinements23171846overrefinements
recrements1449356____re_crements
refinements1646796____refinements
reinstatements1661916re_instatements
remeasurements18141486rem_easurements
remitments1446846remi__t___ments
requirements2384046re___quirements
resettlements1553216re__settlements
revilements1647136____revilements
secretiveness1865866se_cretivene_ss
securements1545496s____ecurements
sentiments1248276se___nti__ments
settlements1345546s____ettlements
startlements1453396s_tar_t_lements
temperaments1853666tem_pe__raments

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 Filter178691950240.360496363.9
2DLD Change Limit95024427.45312749.8
3Display Results42420.0331272.7
 (SQL Overall)178691427.84622774.8
 
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.