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

125 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
deploring133785(None) 
deploying1636151deploying
declaring1339572declaring
decoloring1486312decoloring
deplaning1338052deplaning
depleting1378192depleting
deploringly1852272deploringly
depluming1544712depluming
deponing121211212dep_oning
deporting1369592dep_orting
deposing12129772dep_osing
exploring1945542exploring
imploring1445572imploring
replowing1537412replowing
bellowing1547193bellowing
cellaring1238533cellaring
censoring1238783censoring
coloring11414843_coloring
deaconing1337193deaconing
deairing10311893de_airing
dealing94323233deal__ing
debarring1335723debarring
deboning12109153de_boning
declawing1636213declawing
declining13129353declining
decoding132410053de_coding
decolouring1583433decolouring
decoying15208763de_coying
deferring1436143deferring
deflating142610713deflating
defleaing1444743defleaing
deflowering1952653deflowering
deforcing1636063de_forcing
deforming1636703de_forming
deglazing2135133deglazing
dehorning1455243de_horning
dehorting1447213de_horting
delating103119603de_lating
delaying133210973de_laying
deleing93313953de_l_eing
deleting103314423de_leting
deliming12310373de_liming
delousing1136303de_lousing
deluding1137683de_luding
deluging1137123de_luging
delving123711573de_l_ving
demoing11311753de_mo_ing
demoting12311423de_moting
demurring1335253demurring
denoting10311753de_noting
departing1349513departing
depending14208783depending
depeopling1642643depeopling
deperming1537113deperming
depicting1537813depicting
depilating1439193depilating
deplore1039483deplor__e
deplored1237233deplor_ed
deplorer1136343deplor_er
deplorers1245463deplorers
deplores1139533deplor_es
depraving1635973depraving
depriving1636403depriving
deputing12238793dep_uting
desiring10312143de_siring
desorbing1346363de_sorbing
despairing1445063despairing
deterring1138623deterring
detouring1136973detouring
detoxing1736313de_toxing
developing1743673developing
devolving1733983devolving
devoting1338823de_voting
devouring1435953devouring
dewooling1444323dewooling
deworming1635043de_worming
dialoging1246313dialoging
diplomaing1643573diplomaing
disploding1575873disploding
doctoring1346183doctoring
dolloping1344993dolloping
duplexing2042793duplexing
eloping103512833_e_loping
employing1765343employing
encoring11312173_encoring
exploding2044933exploding
fellowing1655923fellowing
hectoring1538303hectoring
helloing12159123hello_ing
imploding1545213imploding
leporine1049303lep_orine
mellowing1545893mellowing
mentoring1239543mentoring
peppering1337083peppering
plowing133111723__plowing
ploying132811573__ploying
poring94227273__p_oring
reboring11312783re_boring
recoloring1367583recoloring
redeploying1842703redeploying
reexploring2152593reexploring
reflowing1636523reflowing
reglowing1436173reglowing
repairing12310013repairing
replacing142210163replacing
replating122217403replating
replaying15259603replaying
replotting1357043replotting
replying14269403repl_ying
repolling122110203repolling
reporting12513903rep_orting
reposing111213803rep_osing
repouring12310073repouring
reprobing1438073reprobing
reproving1538413reproving
rescoring12310603rescoring
restoring10314613restoring
sectoring1239583sectoring
spooring113111463_spooring
sporing104319413_sp_oring
tailoring1036403tailoring
vaporing1437653vap_oring
vectoring1537413vectoring
veluring1237563ve_luring
yellowing1655073yellowing

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 Limit1486411256.83021763.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.29624491.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.