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 “defoaming” 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
defoaming164565(None) 
defaming15238461def_aming
deforming1636701deforming
defacing15238682def_acing
defeating142311972defeating
deflating142610712deflating
defogging1653862defogging
deforcing1636062deforcing
defraying1735852defraying
deworming1635042deworming
foaming133612992__foaming
reforming1538562reforming
reframing1538622reframing
beaming123618803be__aming
becoming1538163beco_ming
befogging1773413befogging
befooling1535053befooling
befouling1534983befouling
bemoaning1435953bemoaning
benaming1339693be_naming
beshaming1735673beshaming
beworming1734553beworming
coaming123818323__coaming
dealing94323233de__aling
deaning94020473de__aning
deaving123814753de__aving
debasing12238063de_basing
debating123213733de_bating
debeaking1735923debeaking
deboning12109153debo_ning
decamping1734943de_camping
decaying15239453de_caying
deceasing1338403deceasing
declaiming1644783declaiming
declaring1339573declaring
declawing1636213declawing
decocting1538123decocting
decoding132410053deco_ding
decorating14312073decorating
decoying15208763deco_ying
deejaying2142753deejaying
deeming113913123de__eming
defang1137753def_a__ng
defanging1535333defanging
defatting1436103defatting
defecating17237783defecating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
defilading1643643defilading
defiling132812463def_iling
defining133711803def_ining
defleaing1444743defleaing
defoam1238563defoam___
defoamed15356243defoam_ed
defoamer14276213defoam_er
defoamers15285253defoamers
defoams1336193defoam__s
defocusing1752813defocusing
defoliating1645823defoliating
deformity1843033deformity
defragging1742823defragging
defrauding1642923defrauding
defrocking2143153defrocking
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defusing13227933def_using
defuzing22195253def_uzing
defying15328823def__ying
degerming1435753degerming
deglazing2135133deglazing
degrading13137373degrading
degumming1643133degumming
dehorning1455243dehorning
dehorting1447213dehorting
delating103119603de_lating
delaying133210973de_laying
deleading1237773deleading
deleaving1436263deleaving
deliming12310373de_liming
delousing1136303delousing
demeaning1337243demeaning
demobbing1743493demobbing
demoing11311753demo__ing
demoting12311423demo_ting
denoting10311753deno_ting
deperming1537113deperming
deplaning1338053deplaning
depluming1544713depluming
deponing121211213depo_ning
deporting1369593deporting
deposing12129773depo_sing
depraving1635973depraving
derating103222283de_rating
derogating1348633derogating
desolating1239463desolating
desorbing1346363desorbing
detonating1248823detonating
detouring1136973detouring
detoxing1736313deto_xing
deviating14311083deviating
devoicing16145223devoicing
devolving1733983devolving
devoting1338823devo_ting
devouring1435953devouring
dewaxing20215293de_waxing
dewooling1444323dewooling
doating93816863d__oating
doming104218393d__o_ming
dooming113112533d__ooming
dreaming124011063d_reaming
effacing1744463_effacing
enflaming1545633enflaming
enframing1546113enframing
faming124922973__f_aming
flaming134216443__flaming
foaling113515843__foaling
forming133615733__forming
framing133014793__framing
gloaming12268013_gloaming
inflaming1546263inflaming
informing1537023informing
loaming103613733__loaming
performing1844943performing
preforming1846233preforming
reaming103924013re__aming
recoaling121312453recoaling
recoating121317463recoating
refacing142512813ref_acing
refilming15256463refilming
reflating132514713reflating
refloating14198323refloating
refolding1437453refolding
reforging1437663reforging
reloading1189883reloading
reloaning10710483reloaning
renaming11313693re_naming
resoaking1439373resoaking
reteaming122110443reteaming
roaming103215793__roaming
seaming103222113se__aming
teaming103917593te__aming
venoming1436403veno_ming

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 Limit1486411466.58022589.8
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.06325299.6
 
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.