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

148 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
debeaking173592(None) 
debarking1735382debarking
debasing12238062deb_asing
debating123213732deb_ating
debearding1543732debearding
debunking1733352debunking
deceasing1338402deceasing
defeating142311972defeating
deleading1237772deleading
deleaving1436262deleaving
demeaning1337242demeaning
baking135626623__b_aking
beading113221863__beading
beaming123618803__beaming
beaning103820683__beaning
bearing103624773__bearing
beating104326873__beating
becking164416073__becking
bedecking1934283bedecking
beheading1636163beheading
beleaping1436743beleaping
bemeaning1436193bemeaning
beraking153612973be_raking
bereaving1537573bereaving
bespeaking1944393bespeaking
betaking153010153be_taking
braking143917713__braking
breaking153914253_breaking
creaking153414123_creaking
deaerating12311563deaerating
dealing94323233d__ealing
deaning94020473d__eaning
deaving123814753d__eaving
debagging1533593debagging
debarring1335713debarring
debeak1336763debeak___
debeaked1634613debeak_ed
debeaks1436103debeak__s
debiting122511203deb_iting
deboning12109153deb_oning
debriding1446483debriding
debugging1542993debugging
debuting12268633deb_uting
decaying15239453de_caying
deceiving1635733deceiving
decerning1337293decerning
decking153915593d__ecking
declaring1339573declaring
declawing1636213declawing
decreasing1446513decreasing
deeding103315123de_e_ding
deejaying2142753deejaying
deeming113913123de_e_ming
defacing15238683de_facing
defaming15238463de_faming
defecating17237783defecating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
deflating142610713deflating
defleaing1444743deflea_ing
defoaming1645653defoaming
defraying1735853defraying
degerming1435753degerming
deglazing2135133deglazing
degrading13137373degrading
degreasing1345423degreasing
dejecting20217793dejecting
dekeing13358353deke__ing
deking125614553d__e_king
delating103119603de_lating
delaying133210973de_laying
delegating1337673delegating
deleing93313953dele__ing
deleting103314423dele_ting
demarking1736773demarking
dementing13311043dementing
demerging1436643demerging
depending14208783depending
deperming1537113deperming
deplaning1338053deplaning
depraving1635973depraving
derating103222283de_rating
deserting11713143deserting
deserving1497903deserving
desexing1736293dese_xing
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
deticking1736043deticking
deveining1436393deveining
develing133212733deve_ling
devesting14249903devesting
deviating14311083deviating
dewaxing20215293de_waxing
diseasing11310833diseasing
dogearing1235763dogearing
dreading113712803d_reading
dreaming124011063d_reaming
freaking163611453_freaking
hebetating1645793hebetating
keeking114210893ke_e_king
leaking123616973__leaking
peaking144317693__peaking
peeking144414953pe_e_king
phreaking1936473phreaking
prebaking1838063preb_aking
reawaking17216073reawaking
rebating112418343reb_ating
rebelling122111163rebelling
rebooking16146393rebooking
rebuking1536693reb_uking
reeking123318643re_e_king
regearing112211413regearing
rehearing132211763rehearing
reheating132314913reheating
releasing10411013releasing
remaking152613303re_making
repealing122513543repealing
repeating122618983repeating
reperking1638703reperking
rereading111212713rereading
resealing102115673resealing
reseating102421533reseating
reseeking14208493reseeking
resoaking1439373resoaking
respeaking1736803respeaking
retaking133114283re_taking
reteaming122110443reteaming
retearing102214253retearing
revealing132611883revealing
rewaking162310983re_waking
rewearing132310703rewearing
reweaving16227073reweaving
screaking16228243screaking
seeking124016063se_e_king
sneaking133211093_sneaking
speaking153212493_speaking
squeaking2334213squeaking
streaking142010323streaking
tweaking1635883_tweaking
unbearing1239353unbearing
unbraking1636933unbraking
upbearing1435033upbearing
wreaking163010213_wreaking

Search took 9 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.450397091.1
2DLD Change Limit1486411487.84618944.8
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.35921377.1
 
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.