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

269 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
defangs123536(None) 
defang1137751defang_
dangs75623202d__angs
deans66131392de_an_s
debags104211062deba_gs
decanes103118912decanes
decants103514442decants
dedans85915072dedan_s
defaces133213402defaces
defames132812252defames
defanged1435432defanged
defats105114552defa_ts
defends12358772defends
defines114118682defines
defogs1156682def_ogs
defrags1236192defrags
defunds12376752defunds
demands114311412demands
derange939812derange
deranges1039972deranges
desands94810162desands
dewans105215142dewan_s
fangs96224072__fangs
penangs10268372penangs
rehangs1137562rehangs
bangs85627773__bangs
beanos85516513be_anos
beans75734693be_an_s
befalls12349123befalls
beflags1355493beflags
befogs1246453bef_ogs
beings94613033be_ings
belongs10408223belongs
bezants1877343bezants
bhangs12449663_bhangs
cetanes9315133cetanes
changs125215373_changs
clangs95113613_clangs
dags66642603d__a_gs
damans94715983daman_s
dang65131543d__ang_
dans56748153d__an_s
darings93713653darings
deads75726913de_a_ds
deafens11317253deafens
deafness1236213deafness
deairs74013783de_airs
dealings103510703dealings
deals65435343de_a_ls
dean56039483de_an__
deaned84620453de_aned
dears65736883de_a_rs
deaths105914443de_aths
deaves105319533de_aves
debag94212303deba_g_
debarks14388493debarks
debars94218043deba_rs
debases103814133debases
debates103718533debates
debones103315113debones
debugs10467823de_bugs
debunks1433763debunks
decades113615513decades
decafs124010883deca_fs
decalogs1245633decalogs
decals93717713deca_ls
decamps1435643decamps
decanal1038113decanal
decane93818873decan_e
decant93524223decan_t
decares102818533decares
decays124612913deca_ys
deckings16346683deckings
deewans11306903deewan_s
deface123113863defa_ce
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defacing15238683defacing_
defame123212433defa_me
defamed14309833defamed
defamer132710323defamer
defamers14258523defamers
defaming15238463defaming_
defanging1535333defanging
defat95426693defa__t
default1147893default
defaults1243333defaults
defeats113511233defeats
defects134511523defects
defence1339893defence
defences1439633defences
defend113910493defen_d
defense1137503defense
defenses1237913defenses
defers105116943def_ers
defiance1477633defiance
defiances1557033defiances
defiant11311923defian_t
defiers113913993defiers
defies104624053def_ies
defiles114016843defiles
define104718143defin_e
defined123813823defined
definer114413773definer
definers124211193definers
defis96717503def__is
deflates123013943deflates
defleas1147223defleas
defoams1336193defoams
defocus1335283defocus
defog1048523def_og_
deforms1337803deforms
defrag1136463defrag_
defrauds1343243defrauds
defrays1436113defrays
deftness1236303deftness
defuels11296983defuels
defunct1345773defunct
defund11447983defun_d
defuses114814593defuses
defuzes20398303defuzes
defying15328823defying_
degage92711383dega_ge
degames113312623degames
degamis11268443degamis
degas75119163dega__s
degases93413103degases
degauss933923degauss
deigns8389983deign_s
dekares122710873dekares
deking125614553deking_
delaines9312963delaines
delates83526283delates
delays104014053dela_ys
demagogs1343883demagogs
demand104314253deman_d
demarks14339233demarks
demasts1089223demasts
demeans1039723demean_s
dements103016623dements
demons94917723demon_s
denars74621433dena_rs
denes65639723de__nes
dens55945073de__n_s
dents65031803de__nts
deodands1144603deodands
depaints1136643depaints
departs104310683departs
depends11348993depends
deplanes11311213deplanes
depones103717093depones
deraign936573deraign
deraigns1034883deraigns
derails84216393derails
deranged1137693deranged
deranger1037353deranger
derangers1136703derangers
derates84028893derates
derats74625063dera_ts
derays105514253dera_ys
desalts839573desalts
desand84812633desan_d
descants112910143descants
designs9328313designs
desmans1039003desman_s
details84214043details
detains83716093detains
detents83615153detents
devas96218883deva__s
deviants1236733deviants
devons104512253devon_s
dewan95718043dewan__
dewars105117073dewa_rs
dewaxes18297843dewaxes
dewfalls1543073dewfalls
dewing114115703dewing_
dezincs1933753dezincs
dings76331403d__ings
divans104612393divan_s
diwans105110373diwan_s
doings84913183d_oings
dongs76525813d__ongs
dopants1038433dopants
dopings11408783dopings
drags75521113d_ra_gs
dugongs1053253dugongs
dungs75821973d__ungs
dyeings12374643dyeings
dyings11478133d_yings
edgings10256243edgings
elands74914773_elands
elans55527753_elan_s
engs56121393_e__ngs
fags86939123__fa_gs
fanes84639893__fanes
fang85432553__fang_
fanga96119623__fanga
fangas105017193__fangas
fanos85926503__fanos
fans76247373__fan_s
firefangs1643053firefangs
gangs76222573__gangs
gelants82611443gelants
gobangs11385833gobangs
hangs95726723__hangs
hexanes17319463hexanes
infants102210773infants
jeans126022113je_an_s
kiangs11378363_kiangs
leans55536253le_an_s
legongs934543legongs
lemans85316393leman_s
levants1037723levants
liangs74410593_liangs
means75831233me_an_s
melange1038363melange
melanges1138613melanges
offings14285833offings
orangs74116033_orangs
ourangs8318503ourangs
pangs84628663__pangs
parangs104314373parangs
peags86122843pe_a_gs
peans75437643pe_an_s
pecans101515833pecan_s
pedants10310113pedants
pekans121710553pekan_s
penang92511113penang_
pinangs10267793pinangs
prangs94816233_prangs
recanes93222263recanes
recants93217093recants
redans75421023redan_s
refaces123216743refaces
refalls103312243refalls
refinds114512123refinds
refines105426343refines
reflags1156953reflags
refunds11448623refunds
rehang1039823rehang_
relands85214883relands
remands104914883remands
remans84823003reman_s
retags73414303reta_gs
satangs8479713satangs
secants93413893secants
sedans74816093sedan_s
seeings84411293seeings
sewans95215903sewan_s
sewings11369173sewings
shebangs1443593shebangs
slangs75615343_slangs
sprangs104610053sprangs
stangs75018163_stangs
tangs65028343__tangs
tenants7311013tenants
tetanus737933tetanus
trepangs11205403trepangs
twangs10358093_twangs
unhangs1136203unhangs
vangs96319583__vangs
vegans103910853vegan_s
weans85326743we_an_s
whangs13439723_whangs
wrangs104611913_wrangs
yangs95618693__yangs
yeans86624883ye_an_s
zenanas16286233zenanas

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272696.92319359.7
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.41924085.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.