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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
depriving163640(None) 
depraving1635971depraving
deriving132510741de_riving
debriding1446482debriding
deceiving1635732deceiving
deriding112512932de_riding
driving123910712d__riving
redriving1437602redriving
repricing14310472repricing
reprieving1644892reprieving
reprising12312552reprising
reproving1538412reproving
apprising1447963apprising
apprizing2347193apprizing
approving1745053approving
arriving1237363_arriving
becriming1646363becriming
begriming1545533begriming
beriming13310463be_riming
coderiving1744993code_riving
codriving1645213codriving
deairing10311893de_airing
deaving123814753de__aving
debiting122511203de_biting
debriefing1742113debriefing
debruising1443523debruising
deciding132210833de_ciding
declining13129353declining
decreeing1335523decreeing
decrying15237413decr_ying
decurving1634723decurving
defiling132812463de_filing
defining133711803de_fining
defraying1735853defraying
degrading13137373degrading
deicing11312193de__icing
deleaving1436263deleaving
deliming12310373de_liming
delving123711573de__lving
demeriting1448683demeriting
demising122012523de_mising
deorbiting1445153deorbiting
depainting14156153depainting
departing1349513departing
depending14208783depending
deperming1537113deperming
depicting1537813depicting
deplaning1338053deplaning
depleting1378193depleting
deploring1337853deploring
deploying1636153deploying
depluming1544713depluming
deponing121211213dep_oning
deporting1369593deporting
deposing12129773dep_osing
depositing1446933depositing
depravity1842793depravity
depressing1448093depressing
deprival1444603depriv_al
deprivals1543533deprivals
deprive1338303depriv__e
deprived1546463depriv_ed
depriver1446293depriv_er
deprivers1545213deprivers
deprives1438393depriv_es
depurating1438643depurating
deputing12238793dep_uting
deputizing2344803deputizing
derailing112011313derailing
derating103222283de_rating
describing1645073describing
deserving1497903deserving
desiring10312143de_siring
despairing1445063despairing
despising13167503despising
despiting13179323despiting
despoiling1445113despoiling
destining11311433destining
detailing112510413detailing
detaining112510473detaining
detraining1267673detraining
detruding1245193detruding
deveining1436393deveining
deviling1311812853de_viling
devising133111523de_vising
devoicing16145223devoicing
devolving1733983devolving
disprizing2347923disprizing
disproving1746293disproving
diving113717953d___iving
drivings13265763d__rivings
droving12379683d__roving
improving1745413improving
meriting11314683me_riting
nerving112910833ne_r_ving
peptizing2347113peptizing
periling11316863pe_riling
prepricing1746733prepricing
pricing123417343__pricing
priding113317543__priding
priming123417373__priming
prising103321453__prising
prizing193514683__prizing
proving134214073__proving
receiving1538993receiving
regiving13269713re_giving
reiving113316843re__iving
reliving122713343re_living
repairing12310013repairing
repaving142810743rep_aving
repining114116593rep_ining
reprinting131510583reprinting
reprobing1438073reprobing
rerising93017783re_rising
restriving1448133restriving
retrieving1445293retrieving
reviving152910503re_viving
rewriting13310413rewriting
riving104521423___riving
scriving14258763_scriving
serving113014983se_r_ving
shriving15268453_shriving
striving122611393_striving
thriving15246353_thriving
updiving1534223_updiving
uprising1138953_uprising

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411267.22020587.4
3Display Results1261260.1101145.5
 (SQL Overall)1786911267.75023056.9
 
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.