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

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

74 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
recommending205323(None) 
recommencing2153331recommencing
commending1846632__commending
recompensing1953862recompensing
commanding1845923__commanding
commencing1946183__commencing
commenting1749173__commenting
discommending2261913discommending
recementing1645223rec_ementing
recombining1844453recombin_ing
recommend1664323recommend___
recommended1953143recommend_ed
recommender1852723recommend_er
recommenders1952123recommenders
recommends1763163recommend__s
recommitting1954133recommitting
recondensing1653693recondensing
reconvening1746293reconven_ing
remending132311313re___mending
commercing1955974__commercing
communing16207864__commun_ing
contending1449124__contending
emending12298894_e___mending
incommoding1952804incomm_oding
reascending1544274re_ascending
reblending1455814re__blending
rebounding1435304rebo__unding
receding122713764rec___e_ding
recoding122213854reco____ding
recoining121313804reco__in_ing
recollecting1764084recollecting
recombing1637324reco_m__bing
recommence1855154recommen__ce
recommenced2053814recommen_ced
recommences1954924recommen_ces
recommendable2271934recommendable
recommendation2183224recommendation
recommendations22113094recommendations
recompiling1843994reco_mpiling
recomposing1844224reco_mposing
recomputing1844344reco_mputing
reconceiving2093454reconceiving
reconferring1853724reconferring
reconfining1745114reconfin_ing
reconnecting1745354reconnecting
reconning121410794reco___nning
reconverting1876404reconverting
reconveying2044634reconve_ying
reconvincing2053164reconvincing
recording131311624reco___rding
recounting1339194reco__unting
recovering1647374reco_ve_ring
redemanding1643484re_demanding
redescending1752574redescending
redounding1345214redo__unding
refounding1545354refo__unding
regimenting1544664re_gimenting
rehammering1953364rehamme_ring
reimmersing1642824re_immersing
relending112412024re___lending
remanding132211144re___manding
reminding132311544re___minding
reopening1248824re_o_pen_ing
reorienting1246354re_orienting
repigmenting1852584repigmenting
reprehending1973474reprehending
reprimanding1882064reprimanding
rereminding1553784re_reminding
resending112313364re___sending
resoftening1543234resoften_ing
resounding1236364reso__unding
resummoning1671954resummon_ing
resuspending1651714resuspending
seconding1337614seco___nding

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 Filter1786911247900.393454684.5
2DLD Change Limit124790746.56319014.2
3Display Results74740.0302466.7
 (SQL Overall)178691746.98625578.4
 
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.