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

152 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
debunks143376(None) 
debunk1365111debunk_
bunks115125082__bunks
debarks14388492debarks
debeaks1436102debeaks
debones103315112debones
debugs10467822debu_gs
debunked1633192debunked
debunker1543092debunker
debunkers1642702debunkers
debuts93911752debu_ts
defunds12376752defunds
drunks11427512d_runks
dunks105621192d__unks
banks115527903__banks
bohunks1632943bohunks
bonks116326463__bonks
bucks134824293__bucks
bulks115920613__bulks
bunas75126573__bunas
bunds85523543__bunds
bungs85323863__bungs
bunk105731353__bunk_
bunko115514513__bunko
bunkos124210323__bunkos
bunns74718293__bunns
buns66243723__bun_s
bunts75729803__bunts
busks115521373__busks
chunks154210333_chunks
clunks124811013_clunks
daunts75014083d_aunts
deans66131393de_an_s
debags104211063deb_ags
debark134210943debark_
debars94218043deb_ars
debases103814133debases
debates103718533debates
debeak1336763debeak_
debits94214503deb_its
debone93714783debon_e
deboned113411633deboned
deboner103110483deboner
deboners11268113deboners
debris93311493deb_ris
debs76530243deb___s
debtors1038533debtors
debts86418373deb__ts
debug94210063debu__g
debunking1733353debunking
debut86024143debu__t
debutants1243713debutants
debuted11379333debuted
debyes1238103deb_yes
decanes103118913decanes
decants103514443decants
decks124822193de__cks
dedans85915073dedan_s
deduces1168793deduces
deducts1166593deducts
defangs1235363defangs
defends12358773defends
defines114118683defines
defuels11296983defuels
defunct1345773defunct
defund11447983defun_d
defuses114814593defuses
defuzes20398303defuzes
degums10438623degu_ms
degusts936063degusts
deigns8389983deign_s
deludes91810643deludes
deluges9169263deluges
demands114311413demands
demarks14339233demarks
dements103016623dements
demons94917723demon_s
demounts1135473demounts
demurs939773demu_rs
denes65639723de__nes
dens55945073de__n_s
dents65031803de__nts
denudes91510043denudes
depends11348993depends
depones103717093depones
deputes104911783deputes
desands94810163desands
desks105913073de__sks
detents83615153detents
deticks1437353deticks
deuces94015513de_uces
devons104512253devon_s
dewans105215143dewan_s
dezincs1933753dezincs
dibbuks1643163dibbuks
diebacks1745963diebacks
dinks105927953d__inks
drinks116810713d_rinks
drouks1137123drou_ks
drunk10549843d_runk_
ducks124823213d__ucks
dunes65332173d__unes
dungs75821973d__ungs
dunk96228573d__unk_
duns55140433d__un_s
dunts65828413d__unts
dusks105317253d__usks
dybbuks1941603dybbuks
ebons74316093_ebon_s
ebooks12358333_ebooks
embanks15295703embanks
flunks13469863_flunks
funks125318913__funks
gerunds935183gerunds
gunks104517723__gunks
hunks125321453__hunks
junks164815973__junks
kebbucks1742353kebbucks
lebens8310093leben_s
lunks94822453__lunks
nebulas957583nebulas
neuks96510863ne_u_ks
nubucks1544003nubucks
plunks124711163_plunks
punks114822683__punks
rebecks15288013rebecks
rebinds104511873rebinds
rebooks134010513rebooks
rebounds1156023rebounds
rebuffs1533403rebuffs
rebuke124010123rebu_ke
rebukes134210553rebukes
rebus75721113rebu__s
rebuses94915293rebuses
rebuts84015193rebu_ts
rebuys11428783rebu_ys
refunds11448623refunds
reinks105012153re_inks
relinks114510223relinks
reruns66413743rerun_s
retunes76918403retunes
roebucks1643743roebucks
sebums10369813sebu_ms
skunks9468163_skunks
spelunks1442363spelunks
spunks12349333_spunks
tabuns8489223tabun_s
thunks13459033_thunks
trunks10429753_trunks
yeuks125110093ye_u_ks
zebecks24274193zebecks
zebus164610053zebu__s

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271526.22021547.7
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.68626726.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.