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

346 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
deckels1436736(None) 
deckel134911041deckel_
deckers144413831deckers
deckles143312801deckles
beckets15399822beckets
dackers143417042dackers
decals93717712dec_als
decibels1344522decibels
deciles104417722deciles
decked145217622decke_d
decker135215992decke_r
deckle1312012452deck_le
decks124822192deck__s
decrees102513122decrees
defuels11296982defuels
dekes105224452de_ke_s
devels104313902de_vels
dickens144410132dickens
dickers144117662dickers
dickeys17479302dickeys
dockers143715002dockers
dockets144412242dockets
duckers143214712duckers
heckles163711382heckles
keckles12318762keckles
neckers134210462neckers
nickels13338652nickels
peckers153312672peckers
ackees124914583_ackees
backers153821883backers
beakers134216873beakers
becked155417763becke_d
becket144619883becke_t
beckons15279143beckons
becks135522013beck__s
bedels94015273be_dels
betels84515063be_tels
bethels1238533bethels
bevels113913983be_vels
bezels173712283be_zels
bickers154316553bickers
buckers153517453buckers
buckets153811693buckets
buckles153416093buckles
cackles153717203cackles
cels65534973__c_els
checkers19317843checkers
cockers153618333cockers
cockles153414643cockles
daces85030683dac_e_s
dacker134920753dacke_r
dactyls1333913dactyls
daikers124010313daikers
damsels10126703damsels
darkens12409873darkens
darkeys15356533darkeys
darkles124011933darkles
darnels83710433darnels
deadens93410693deadens
deafens11317253deafens
dealers84118613dealers
deals65435343de__als
deaves105319533deave_s
debyes1238103debye_s
decades113615513decades
decafs124010883dec_afs
decal85523233dec_al_
decamps1435643decamps
decanes103118913decanes
decants103514443decants
decares102818533decares
decayers14307963decayers
decays124612913dec_ays
decease1049523dec_ease
deceit93018213dec_eit
deceits102810883deceits
decent94023703dec_ent
decern91310953dec_ern
decerns10119053decerns
decibel1235993decibel_
deciders123510753deciders
decides114217653decides
decile94619213dec_ile
decimals1345863decimals
deck115827753deck___
decking153915593decking
deckings16346683deckings
declass1038733declass
declaws1336253declaws
decocts1237833decocts
decoders122810413decoders
decodes113914983decodes
decors94017773dec_ors
decos85522123dec__os
decoyers14287713decoyers
decoys123911283dec_oys
decrease1136563decrease
decree93117783decre_e
decreed112710253decreed
decreer10269123decreer
decreers11277623decreers
decretals1245093decretals
decrials1137133decrials
decriers11299733decriers
decries103319803decries
decuple1285363decuple
decuples1395283decuples
deeds75423763de__eds
deems85421773de__ems
deepens10307813deepens
deeps84921773de__eps
deers64930523de__ers
dees56356633de__e_s
deets65330243de__ets
defers105116943de_fers
defiers113913993defiers
defies104624053defie_s
defiles114016843defiles
defleas1147223defleas
defuel10348933defuel_
degrees92810723degrees
deicers103612733deicers
deices94119373deice_s
deils65722863de__ils
deke95228763de_ke__
deked115718533de_ke_d
dekkos1034103de_kkos
deles65139253de_le_s
dells66630943de__lls
dels56745473d___els
delvers113411993delvers
delves104917083delve_s
demes86032693de_me_s
demies94825803demie_s
denes65639723de_ne_s
denials84114133denials
deniers84515183deniers
denies74729643denie_s
densely1146713densely
dentals83915393dentals
dentils84115583dentils
depress10239873depress
derails84216393derails
desks105913073desk__s
details84214043details
deters74724683de_ters
detickers1634423detickers
deuces94015513deuce_s
devel94217123de_vel_
devils104412813de_vils
dewless1137473dewless
dewools1145593dewools
dexes135224513de_xe_s
dexies145018343dexie_s
dicers94720743dic_ers
dices86434243dic_e_s
dicked144920863dicke_d
dicker134521403dicke_r
dickey165913523dicke_y
dickies143416343dickies
dicks125824693dick__s
diesels8429143diesels
dikers114418793d_ikers
dikes105831333d_ike_s
dinkeys15507263dinkeys
dispels10310503dispels
djebels1753293djebels
docked145018333docke_d
docker134417653docke_r
docket134721173docke_t
docks126022313dock__s
donkeys15426663donkeys
donzels1735393donzels
dorsels84412573dorsels
dossels85511603dossels
dottels8327783dottels
dowels104813343d_owels
drakes114715863drake_s
drecks13459203dreck__s
dreidels1033213dreidels
drivels11397923drivels
duces86327473duc_e_s
duchess1335553duchess
ducked144718013ducke_d
ducker134317993ducke_r
duckies143613813duckies
ducks124823213duck__s
duels65619233d__uels
duffels14296453duffels
duikers12369383duikers
dukes105023473d_uke_s
dunkers123512193dunkers
dykes135215573d_yke_s
dynels10536813d_ynels
easels65914553_easels
eches106322163_eche_s
eels46536743_e__els
ekes86726603_e_ke_s
eskers105312223_eskers
excels1536663_excels
expels1547173_expels
feces105625363fec_e_s
fecials123510333fecials
feckless17225783feckless
feckly18335963feck_ly
fecks145417853feck__s
feels85223043fe__els
fennels10387903fennels
ferrels10248623ferrels
freckles17126383freckles
fuckers163611593fuckers
gecked146911933gecke_d
geckoes14325793geckoes
geckos13457433geck_os
gecks125117093geck__s
hackees165014103hackees
hackers164619043hackers
hackles162917063hackles
heckle153112093heck_le
heckled17318463heckled
heckler16278573heckler
hecklers17357123hecklers
hecks145220653heck__s
heels85625533he__els
hickeys19508223hickeys
hockers163915913hockers
hockeys19509273hockeys
huckles163612623huckles
ickers123914183_ickers
jackals2036893jackals
jackers204214453jackers
jackets205011373jackets
jebels15418913je_bels
jerkers18287083jerkers
jewels16508613je_wels
jockeys23365953jockeys
kecked125113163kecke_d
keckle11359423keck_le
keckled13376503keckled
kecks105416573keck__s
keels94622413ke__els
kennels11387193kennels
kernels11417953kernels
kevels134410713ke_vels
kickers124013293kickers
lackers134120543lackers
lackeys16458263lackeys
leakers113415423leakers
lechers123313963lechers
leches115421313leche_s
levels94113283le_vels
lickers134118253lickers
lockers133516923lockers
lockets134612203lockets
mackles154415753mackles
mickeys18447943mickeys
mickles153415003mickles
mockers153812943mockers
muckers153612803muckers
muckles153413253muckles
necked134715063necke_d
necker124012793necke_r
neckless14236433neckless
necks115119333neck__s
newels93710823ne_wels
nickel123811343nickel_
nickers134415093nickers
nickles133713823nickles
ockers123813903_ockers
packers153818893packers
packets155114773packets
pecked155019103pecke_d
pecker144615363pecke_r
pecks135724433peck__s
pectens11189203pectens
peels75226423pe__els
pekes114623563pe_ke_s
pencels113610053pencels
petrels9279373petrels
pickers153718093pickers
pickets154314183pickets
pickles153215443pickles
pockets154612253pockets
puckers153514673puckers
rackers134320453rackers
rackets134916873rackets
rebels84518133re_bels
recalls92613623recalls
recces10614913recce_s
recess8314263rec_ess
rechews1537293rechews
recked134821803recke_d
reckless14257973reckless
reckons13269653reckons
recks115625133reck__s
recoals94214623recoals
recoils93814873recoils
reekers113613143reekers
reels55333263re__els
refeels10379693refeels
refels94618053re_fels
refuels10399523refuels
reheels10298253reheels
rekeys13347693re_keys
repels84318763re_pels
revels94220573re_vels
rickets134915093rickets
rickeys16548983rickeys
rockers133916553rockers
rockets134615363rockets
ruckles133414603ruckles
sackers133820223sackers
secrets9311773secrets
seekers113712333seekers
seels55632823se__els
seidels838393seidels
sequels1665703sequels
shekels1436043shekels
sickees134514213sickees
sickens134411483sickens
sickles133417543sickles
sockets134012983sockets
speckles16268133speckles
suckers133717623suckers
suckles134516743suckles
tackers134319623tackers
tackets134914363tackets
tackles133816523tackles
teasels74311313teasels
teazels16406893teazels
teels55726373te__els
tercels94110363tercels
tickers133617723tickers
tickets134113683tickets
tickles133416853tickles
tuckers134014353tuckers
tuckets134810333tuckets
vessels1035933vessels
wackes154717713wacke_s
weakens14367063weakens
weasels10468503weasels
wedels103811033we_dels
wickers164114703wickers
wickets164010943wickets
wreckers17315973wreckers
yokels13488063_yokels

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.406440125.6
2DLD Change Limit1340273465.90622693.4
3Display Results3463460.1262746.0
 (SQL Overall)1786913466.43827755.7
 
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.