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 “deforcing” 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
deforcing163606(None) 
deforming1636701deforming
defacing15238682def_acing
defencing16226692defencing
deferring1436142deferring
defoaming1645652defoaming
defogging1653862defogging
defrocking2143152defrocking
dehorning1455242dehorning
dehorting1447212dehorting
deporting1369592deporting
desorbing1346362desorbing
devoicing16145222devoicing
deworming1635042deworming
divorcing1644322divorcing
enforcing1545472enforcing
forcing134013752__forcing
reforging1437662reforging
reforming1538562reforming
affording1744023affording
befogging1773413befogging
befooling1535053befooling
befouling1534983befouling
beworming1734553beworming
deairing10311893deair_ing
debarking1735383debarking
debarring1335723debarring
deboning12109153debo_ning
debouching1942723debouching
decerning1337293decerning
decocting1538123decocting
decoding132410053deco_ding
decorating14312073decorating
decoying15208763deco_ying
decrying15237413de_crying
decurving1634723decurving
deducing1336423de_ducing
defaming15238463def_aming
defanging1535333defanging
defatting1436103defatting
defeating142311973defeating
defecting162510223defecting
defending15298353defending
defensing14217003defensing
defiling132812463def_iling
defining133711803def_ining
deflating142610713deflating
defleaing1444743defleaing
deflecting1736503deflecting
defocusing1752813defocusing
deforce13267243deforc__e
deforced15247373deforc_ed
deforcer14246903deforc_er
deforcers15265503deforcers
deforces14248403deforc_es
deforesting1654793deforesting
deformity1843043deformity
defraying1735853defraying
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defusing13227943def_using
defuzing22195253def_uzing
defying15328823def__ying
degerming1435753degerming
dehiscing1643733dehiscing
deicing11312193de__icing
delousing1136303delousing
demarking1736773demarking
demerging1436643demerging
demobbing1743493demobbing
demoing11311753demo__ing
demoting12311423demo_ting
demurring1335253demurring
denoting10311753deno_ting
denouncing1443883denouncing
departing1349513departing
deperming1537113deperming
deploring1337853deplor_ing
deponing121211213depo_ning
deposing12129773depo_sing
descrying1635103descrying
deserting11713143deserting
deserving1497903deserving
desiring10312143desir_ing
deterging1237853deterging
deterring1138623deterring
detouring1136973detouring
detoxing1736313deto_xing
deucing1139393de__ucing
devolving1733983devolving
devoting1338823devo_ting
devouring1435953devouring
dewooling1444323dewooling
dezincing2244183dezincing
effacing1744463_effacing
farcing133514003__farcing
fording123717043__fording
forging124114723__forging
forking154014843__forking
forming133615733__forming
informing1537023informing
performing1844943performing
preforming1846233preforming
reboring11312783rebor_ing
recording131311623recording
recorking16149643recorking
reenforcing1742773reenforcing
refacing142512813ref_acing
refencing15188853refencing
referring1338033referring
refiring123513923refir_ing
refolding1437453refolding
refrying15278903ref_rying
regorging1236823regorging
reinforcing1743713reinforcing
rejoicing19136943rejoicing
reporting12513903reporting
resorbing1269353resorbing
resorcin1046823resorcin_
resorcins1146983resorcins
resorting10614613resorting
retorting10613273retorting
revoicing15117713revoicing
rewording14158543rewording
reworking17136873reworking

Search took 7 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 Limit1486411266.30023593.8
3Display Results1261260.0602100.0
 (SQL Overall)1786911266.78026355.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.