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

254 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
declaw126670(None) 
declaws1336251declaws
dewclaw1651791dewclaw
claw95624342__claw
decaf114919442dec_af
decal85523232dec_al
decals93717712decals
decay114718482dec_ay
declaim1247362declaim
declare10411222declare
declass1038732declass
declawed1545922declawed
delay94820632de_lay
dewclaws1751872dewclaws
dewlap1264842dewlap
eclat7523602_eclat
reclad9311872reclad
aecia73819283aecia_
aecial84817313aecial
becalm1239203becalm
becap114315053bec_ap
beclasp1335263beclasp
becloak1545043becloak
beclog1136863beclog
beclown1435423beclown
becrawl1444583becrawl
bedlam1149273bedlam
beflag1265883beflag
beglad10138463beglad
belay105021523be_lay
bellow114213353bellow
below104617193be_low
blaw97026723__blaw
byelaw1444253byelaw
bylaw13408603_bylaw
catclaw1443973catclaw
caw86647933__c_aw
ceca84820783cec_a_
cecal94619113cec_al
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
chaw126224633__chaw
clad76225823__clad
clag75924573__clag
clam86332293__clam
clan65633923__clan
clap86429043__clap
claws106020833__claws
clay95927413__clay
clew95520573__clew
craw97725263__craw
dacha114812573dacha_
dachas124113253dachas
daw77148363d___aw
dead65434243de__ad
deaf85838403de__af
deal56347413de__al
dealate83617843dealate
dealer74122143dealer
deals65435343deal_s
dealt65234283deal_t
dean56039483de__an
dear55343603de__ar
debag94212303de_bag
debar85517863de_bar
debeak1336763debeak
decadal1137243decadal
decade104216163decade
decafs124010883decafs
decalog1136003decalog
decamp1338453decamp
decanal1038113decanal
decane93818873decane
decant93524223decant
decare93919153decare
decays124612913decays
decease1049523decease
deceit93018213deceit
decent94023703decent
decern91310953decern
deciare10710663deciare
decide104116873decide
decile94619213decile
deciles104417723deciles
decimal1238083decimal
deck115827753dec__k
decked145217623decked
deckel134911043deckel
decker135215993decker
deckle1312012453deckle
deckles143312803deckles
decks124822193dec_ks
declaims1345823declaims
declared1248743declared
declarer1148063declarer
declares11611313declares
declasse1165943declasse
declawing1636213declawing
decline103716613decline
deco76125973dec__o
decoct11313783decoct
decode104414743decode
decolor1087033decolor
decor84717573dec_or
decors94017773decors
decos85522123dec_os
decoy115716313dec_oy
decoys123911283decoys
decree93117783decree
decrial10310323decrial
decrown13206053decrown
decry115514353dec_ry
decuman1236573decuman
decury1277963decury
dedal75719023de_dal
deejay1734523deejay
deewan10267553deewan
defat95426693de_fat
defeat103817163defeat
deflate113613943deflate
deflea1037443deflea
defleas1147223defleas
defoam1238563defoam
defrag1136463defrag
defray1337643defray
degas75119163de_gas
deglaze1835583deglaze
deil56231623deil__
deils65722863deil_s
del46752753de_l__
delate73827753de_late
delays104014053de_lays
dele56843083de_l_e
delead84112343delead
deled75326543de_led
deles65139253de_les
delf85436573de_l_f
delfs94918673de_lfs
delft95623323de_lft
deli55631293de_l_i
delis64928543de_lis
dell56938203de_l_l
dells66630943de_lls
delly96023873de_lly
dels56745473de_l_s
delt57855273de_l_t
delta66117773de_lta
deltas74414823deltas
delts65731793de_lts
delve96018263de_lve
demean9510563demean
denar65223293de_nar
denial74720513denial
dental74319173dental
deodar837713deodar
deplane10311413deplane
deploy1237583deploy
derat65044083de_rat
deray95024183de_ray
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desalt7518313desalt
desman9311693desman
deva85720983de_va_
devas96218883de_vas
dew77139923de___w
dewan95718043de_wan
dewar95817733de_war
dewax165510853de_wax
dewclawed1941533dewclawed
dewlaps1334663dewlaps
dicta84915633dicta_
dobla84913643dobla_
doblas93812293doblas
dollar74110983dollar
doula65717773doula_
doulas75114993doulas
draw85623013d__raw
ducal84816423duc_al
ducat86225903duc_at
ductal938993ductal
eclair836813_eclair
eclats8313033_eclats
elan46734243_e_lan
fecal105119213fec_al
fecial114714623fecial
fecula113310053fecula_
feculae12339203feculae
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
fellow123712743fellow
flaw106326643__flaw
geegaw1142853geegaw
gelcap1136213gelcap
gewgaw1441783gewgaw
heehaw1543933heehaw
jetlag1434523jetlag
keblah1545313keblah
law68656643___law
macaw12311763mac_aw
mecca1139933mecca_
meccas1239493meccas
medlar93010463medlar
mellow114112223mellow
nectar838853nectar
outlaw9279643outlaw
pecan91919033pec_an
pechan13511543pechan
pedlar93311273pedlar
pepla9312863pepla_
pilaw103913743_pilaw
prelaw1139103prelaw
recall83815723recall
recap95718023rec_ap
rechew14310213rechew
reclads1049993reclads
reclaim1137753reclaim
reclame11411063reclame
reclasp1136643reclasp
reclean938523reclean
recoal84117973recoal
recoat84024273recoat
recta74220263recta_
rectal84418133rectal
redraw10269853redraw
reflag1098083reflag
reflew12389453reflew
reflow12379653reflow
reglow10339403reglow
relax124817803re_lax
relay84424673re_lay
replan83215823replan
replay113412923replay
replow114210343replow
resaw84117253re_saw
secpar1037923secpar
secular92211533secular
seesaw935973seesaw
selah8319613se_lah
slaw77930713__slaw
tecta74215523tecta_
tectal83713253tectal
tela45532973te_la_
telae54323293te_lae
tesla55612603tesla_
teslas64212173teslas
unclad938913unclad
vela75725543ve_la_
velar85817633ve_lar
yclad11246383_yclad
yellow12429883yellow

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 Filter1786911127160.440406115.9
2DLD Change Limit1127162545.45320670.5
3Display Results2542540.0932731.2
 (SQL Overall)1786912545.98629851.5
 
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.