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

248 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
decoyer1334868(None) 
decayer13339351decayer
decoder113712291decoder
decoyed14358331decoyed
decoyers14287711decoyers
coyer105222842__coyer
deboner103110482deboner
decayed14309332decayed
decayers14307962decayers
decider114213182decider
decker135215992dec_ker
decode104414742decode_
decoded123212382decoded
decoders122810412decoders
decodes113914982decodes
decolor1087032decolor
decor84717572deco__r
decoy115716312decoy__
decoys123911282decoy_s
decreer10269122decreer
decrier102713552decrier
delayer113010532delayer
deployer1445632deployer
deposer104011842deposer
recover124312622recover
annoyer1095603annoyer
beckoner1654963beckoner
become123312593become_
becomes132911963becomes
bedcover1663563bedcover
belayer12339503belayer
caloyer1238143caloyer
coder86134223__coder
comer95832693__comer
cooer74831013__cooer
coper95336093__coper
corer75538873__corer
cover105430773__cover
cower104531773__cower
coyed114623803__coyed
dacker134920753dac_ker
deaconed1237493deaconed
deader84220473de_ader
deafer104114813de_afer
dealer74122143de_aler
dearer74822803de_arer
debaser103510413debaser
debater104114693debater
debone93714783debone_
deboned113411633deboned
deboners11268113deboners
debones103315113debones
debye1138903de_bye_
debyes1238103de_byes
decade104216163decade_
decades113615513decades
decane93818873decane_
decanes103118913decanes
decanter112510793decanter
decare93919153decare_
decares102818533decares
decay114718483decay__
decays124612913decay_s
deceiver1436233deceiver
decenter112412163decenter
decern91310953dec__ern
deciare10710663deciare
decibel1235993decibel
decide104116873decide_
decided124312423decided
deciders123510753deciders
decides114217653decides
decile94619213decile_
deciles104417723deciles
decipher1644423decipher
decked145217623dec_ked
deckel134911043dec_kel
deckers144413833dec_kers
deckle1312012453deckle_
deckles143312803deckles
declare10411223declare
declarer1148063declarer
decliner113710843decliner
deco76125973deco___
decoct11313783deco_ct
decocted1437683decocted
decocts1237833decocts
decolors1187713decolors
decolour1185013decolour
decors94017773deco_rs
decorum1246943decorum
decos85522123deco__s
decoupler14113833decoupler
decoying15208763decoying
decree93117783dec_ree
decreed112710253decreed
decreers11277623decreers
decrees102513123decrees
decried112612853decried
decriers11299733decriers
decries103319803decries
decry115514353decry__
decrypt1545703decrypt
deedier93011593deedier
deeper93613503de_eper
deer56739023de___er
defacer132810363defacer
defamer132710323defamer
defer94619753de__fer
deffer134411303de_ffer
defier105118653de_fier
defiler113911883defiler
definer114413773definer
deflower15126073deflower
defoamer14276213defoamer
defogger1443533defogger
deforcer14246903deforcer
deformer14247943deformer
defrayer1534933defrayer
defter104215923de_fter
defuser115110503defuser
dehorner1235523dehorner
deicer94114413de_icer
deifier113013123deifier
delayed123310763delayed
delayers12268663delayers
deliver113312243deliver
delouser936363delouser
deluder9168333deluder
delver104913493de_lver
demode104013463demode_
demoded123611123demoded
demoed103713443demo_ed
demoses103815823demoses
demote94817803demote_
demoted114313543demoted
demotes104717673demotes
demurer1037873demurer
denier74420693de_nier
denote74118043denote_
denoted93512763denoted
denotes83817003denotes
denser74115193de_nser
denuder9167603denuder
deodar837713de_odar
deplorer1136343deplorer
deployed1535913deployed
deployers1545063deployers
depone93616553depone_
deponed113712873deponed
depones103717093depones
deporter1169393deporter
depose94215763depose_
deposed113412023deposed
deposers11359243deposers
deposes103117213deposes
derider93214973derider
deriver114213913deriver
dernier83011943dernier
descrier1157623descrier
desirer8310783desirer
destroyer1344553destroyer
deter65028043de__ter
detour778193deto_ur
detoxed1636103detoxed
detoxes1538803detoxes
deviser114212393deviser
devoir1076033devo_ir
devote104513783devote_
devoted124111093devoted
devotee113811823devotee
devotes113713753devotes
devour1076703devo_ur
devourer1235063devourer
devouter1235513devouter
dewater112912423dewater
dewier104013463de_wier
dewormer14256323dewormer
dexter143810893de_xter
dicer85426423dic__er
dicier94416233dic_ier
dicker134521403dic_ker
dickier143512453dickier
dictier103411863dictier
discover1439563discover
docker134417653doc_ker
doer57734703d__o_er
doozer163910463d_oozer
doper86128393d__oper
doser66228563d__oser
doter65428623d__oter
dower95027703d__ower
doyen95014413d__oyen
dozer158419273d__ozer
droner74717673d_roner
drover104614593d_rover
dryer95111463d__ryer
ducker134317993duc_ker
duckier143911793duckier
dyer85522113d___yer
echoer114011103_echoer
eloper85414153_eloper
emoter85415193_emoter
encoder1038633encoder
enjoyer1744383enjoyer
evoker13467913_evoker
eyer76127283_e__yer
feyer115014523fe__yer
foyer116416553__foyer
heckler16278573heckler
incomer1169943incomer
lecher113415853lec_her
necker124012793nec_ker
newcomer1543343newcomer
oyer75927653___oyer
pecker144615363pec_ker
peckier153910523peckier
reciter94117263reciter
reckoner1446063reckoner
recode93618713recode_
recoded113115033recoded
recodes102918633recodes
recoiler103210493recoiler
recolor978693recolor
reconfer1337673reconfer
recorder11249633recorder
recovers133511123recovers
recovery16366213recovery
remoter94815973remoter
remover124612273remover
reposer93715333reposer
repower12329883repower
revoker14419193revoker
scorer84818263_scorer
scoter83815483_scoter
seceder10329573seceder
seconder1137183seconder
securer958253securer
stroyer103510783stroyer
techier1269243techier
tenoner739683tenoner
toyer84521553__toyer
tutoyer1033793tutoyer
uncover1239003uncover
venomer1237583venomer
vetoer93410063veto_er
vocoder1334693vocoder
welcomer1544023welcomer

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.406440125.6
2DLD Change Limit1340272487.34318252.3
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.84222786.4
 
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.