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

146 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
deforming163670(None) 
defoaming1645651defoaming
deforcing1636061deforcing
deworming1635041deworming
reforming1538561reforming
beworming1734552beworming
defaming15238462def_aming
deferring1436142deferring
defogging1653862defogging
deformity1843032deformity
degerming1435752degerming
dehorning1455242dehorning
dehorting1447212dehorting
deperming1537112deperming
deporting1369592deporting
desorbing1346362desorbing
forming133615732__forming
informing1537022informing
performing1844942performing
preforming1846232preforming
reforging1437662reforging
affirming1843103affirming
affording1744023affording
ausforming1642503ausforming
becoming1538163beco_ming
befogging1773413befogging
befooling1535053befooling
befouling1534983befouling
berming123614833be__rming
conforming1847373conforming
deairing10311893deair_ing
debarking1735383debarking
debarring1335713debarring
deboning12109153debo_ning
decerning1337293decerning
decocting1538123decocting
decoding132410053deco_ding
decorating14312073decorating
decoying15208763deco_ying
decrying15237413de_crying
decurving1634723decurving
deeming113913123de__eming
defacing15238683def_acing
defanging1535333defanging
defatting1436103defatting
defeating142311973defeating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferment151210303deferment
defiling132812463def_iling
defining133711803def_ining
deflating142610713deflating
defleaing1444743defleaing
defocusing1752813defocusing
deforesting1654793deforesting
deform1259613deform___
deformed15248263deform_ed
deformer14247943deform_er
deformers15266533deformers
deforms1337803deform__s
defraying1735853defraying
defrocking2143153defrocking
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defusing13227933def_using
defuzing22195253def_uzing
defying15328823def__ying
degumming1643133degumming
deliming12310373de_liming
delousing1136303delousing
demarking1736773demarking
demerging1436643demerging
demobbing1743493demobbing
demoing11311753demo__ing
demoting12311423demo_ting
demurring1335253demurring
denoting10311753deno_ting
departing1349513departing
deploring1337853deplor_ing
depluming1544713depluming
deponing121211213depo_ning
deposing12129773depo_sing
descrying1635103descrying
deserting11713143deserting
deserving1497903deserving
desiring10312143desir_ing
deterging1237853deterging
determine1249033determine
deterring1138623deterring
detouring1136973detouring
detoxing1736313deto_xing
devoicing16145223devoicing
devolving1733983devolving
devoting1338823devo_ting
devouring1435953devouring
dewooling1444323dewooling
disarming1338803disarming
divorcing1644323divorcing
doming104218393d__o_ming
dooming113112533d__ooming
dormin9312313d__ormin_
dormins10311273d__ormins
enforcing1545473enforcing
farming133515083__farming
firming132811223__firming
foaming133612993__foaming
forcing134013753__forcing
fording123717043__fording
forging124114723__forging
forking154014843__forking
gorming112810833__gorming
infirming1545163infirming
metformin1663223metformin_
metformins1762963metformins
misforming1845403misforming
nondeforming1992523nondeforming
perming123416093pe__rming
rearming111413613re_arming
reboring11312783rebor_ing
recording131311623recording
recorking16149643recorking
referring1338033referring
refilming15256463refilming
refiring123513923refir_ing
refolding1437453refolding
reformism1643703reformism
reformist1445913reformist
reframing1538623reframing
refrying15278903ref_rying
regorging1236823regorging
reinforming1784043reinforming
reporting12513903reporting
resorbing1269353resorbing
resorting10614613resorting
retorting10613273retorting
rewarming15147383rewarming
rewording14158543rewording
reworking17136873reworking
storming11209423_storming
terming104016003te__rming
uniforming1643793uniforming
venoming1436403veno_ming
worming132811243__worming

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.1701051123.5
2DLD Change Limit1486411467.42320024.4
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.65623340.0
 
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.