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

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
semiretirements19101161semiretirements_
semiretirement18101472semiretirement__
retirements1357615____retirements_
embrittlements2061606_embrittlements_
empressements1962836_empre_ssements_
postretirement1881226postretirement__
preretirement1762716_preretirement__
retirement1259126____retirement__
semiretired1452286semiretir__e___d
advertisements20182857adver_tisements_
advertizements29162277adver_tizements_
belittlements1772067beli__ttlements_
bereavements19154207be__re_avements_
curettements1652487__curet_tements_
debridements1853897de_br__idements_
embattlements1952787_em_battlements_
embezzlements2762007_em_bezzlements_
embitterments19102007_embitter_ments_
embracements2055247_embr__acements_
embranglements21132537_embranglements_
embrittlement1961857_embrittlement__
embroilments1863317_embr_oi_lments_
empressement1853267_empre_ssement__
enticements1598167_e___nticements_
hereditaments1961487he__reditaments_
misrepresents17142207__misre_presents_
misstatements17122907__misstatements_
overrefinements23171847overrefinements_
recrements1449357____re_crements_
refinements1646797____refinements_
reinstatements1661917re_instatements_
remeasurements18141487rem_easurements_
remitments1446847remi__t___ments_
requirements2384047re___quirements_
resettlements1553217re__settlements_
revilements1647137____revilements_
secretiveness1865867se_creti__veness
securements1545497s____ecurements_
sentiments1248277se___nti__ments_
settlements1345547s____ettlements_
startlements1453397s_tar_t_lements_
temperaments1853667tem_pe__raments_

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 Filter178691950240.360496363.9
2DLD Change Limit95024428.70310918.5
3Display Results42420.0331272.7
 (SQL Overall)178691429.09619645.0
 
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.