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

73 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
appreciating195408(None) 
appreciation1855282appreciation
appreciations1964752appreciations
appreciative2153942appreciative
depreciating1845032depreciating
abbreviating2051563abbreviating
appreciate1655223appreciat__e
appreciated1854203appreciat_ed
appreciates1754723appreciat_es
appreciator1754113appreciat_or
appreciators1853513appreciators
appreciatory2153193appreciatory
approbating1844583appr_obating
appropriating1783493appropriating
approximating2761803approximating
deprecating1777283deprec_ating
imprecating1844903imprec_ating
speciating1548123_sp_eciating
accrediting1752464accredi_ting
affricating2043964affric_ating
aggregating1343584aggre_gating
alleviating1553594a_lleviating
altercating1455604alterc_ating
annunciating1552374annunciating
appealing1446494app_e__aling
appearing1436894app_e__aring
appeasing1446344app_e__asing
apperceiving2251964apperceiving
appertaining1752514appertaining
appetising1544514app_eti_sing
appetizing2445404app_eti_zing
appointing1545324app__ointing
appraising1545764appr_ai_sing
appreciable1953844apprecia_ble
appreciably2253044apprecia_bly
appreciatively2672304appreciatively
apprehending2152494apprehending
apprenticing1962304apprenticing
apprising1447964appr__i_sing
apprizing2347194appr__i_zing
arpeggiating1751264arpeggiating
asperating1349564asp_e_rating
asphyxiating2861184asphyxiating
associating1444864a_ssociating
brecciating1844224__brecciating
depreciatingly23131384depreciatingly
depreciation1747074depreciation
depreciations1846574depreciations
depreciative2084084depreciative
depredating1655694depre_dating
excruciating2452374excruciating
impregnating1852844impregnating
inappreciative2361704inappreciative
patriating13510204patr__iating
perennating1445544_perennating
precasting15169834__precasting
precenting151012154__precenting
precising14413274__preci_sing
precutting1546424__precutting
predating13514654__pre_dating
predicating1749654__predicating
predicting1649874__predicting
preheating16310724__preheating
presifting1638084__presifting
reciting113118074___reci_ting
recoating121317464___recoating
recrating121318794___recrating
spectating1546624_sp_ectating
unappreciation2061964unappreciation
unappreciations2181634unappreciations
unappreciative2381604unappreciative
uppercasing1852764upperc_asing
uppercutting1951534uppercutting

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.453394461.4
2DLD Change Limit124790737.42316811.3
3Display Results73730.0461587.0
 (SQL Overall)178691737.92222556.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.