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

270 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
decreer1026912(None) 
decree93117781decree_
decreed112710251decreed
decreers11277621decreers
decrees102513121decrees
decrier102713551decrier
dearer74822802dear_er
decayer13339352decayer
decider114213182decider
decker135215992dec_ker
decoder113712292decoder
decoyer13348682decoyer
decried112612852decried
decriers11299732decriers
decries103319802decries
degree82814852degree_
degreed10258882degreed
degrees92810722degrees
descrier1157622descrier
secreter1038512secreter
acerber1135243acerber
aerier64823153ae_rier
bearer85323913bear_er
beerier93613023beerier
bescreen1244303bescreen
career85822243_career
cheer105420383__cheer
creed85727393__creed
creek114917393__creek
creel75121483__creel
creep95218103__creep
crier74724463__crier
dacker134920753dac_ker
darer65230793d_ar_er
darker114718693d_arker
darner74017303d_arner
darter75320363d_arter
deadener1036743deadener
deader84220473de_ader
deafer104114813de_afer
dealer74122143de_aler
dearest83618673dearest
dearie73319813dearie_
dearies83526273dearies
debarker15155503debarker
debaser103510413debaser
debater104114693debater
deboner103110483deboner
debrief1337623debrief
debriefer1541923debriefer
decade104216163decade_
decades113615513decades
decameter14137363decameter
decane93818873decane_
decanes103118913decanes
decanter112510793decanter
decare93919153decare_
decares102818533decares
decayed14309333decayed
decayers14307963decayers
deceit93018213dec_eit
deceiver1436233deceiver
decent94023703dec_ent
decenter112412163decenter
decern91310953dec_ern
decerned1237263decerned
decerns10119053decerns
deciare10710663deciare
decibel1235993decibel
decide104116873decide_
decided124312423decided
deciders123510753deciders
decides114217653decides
decile94619213decile_
deciles104417723deciles
decimeter14147413decimeter
decipher1644423decipher
decked145217623dec_ked
deckel134911043dec_kel
deckels14367363deckels
deckers144413833deckers
deckle1312012453deckle_
deckles143312803deckles
declare10411223declare
declarer1148063declarer
decliner113710843decliner
decode104414743decode_
decoded123212383decoded
decoders122810413decoders
decodes113914983decodes
decolor1087033decolor
decor84717573dec__or
decoyed14358333decoyed
decoyers14287713decoyers
decrease1136563decrease
decreased1345453decreased
decreases1237223decreases
decreeing1335523decreeing
decrement14411053decrement
decrepit1345873decrepit
decretal1146353decretal
decretory1544683decretory
decrial10310323decrial
decrown13206053decrown
decry115514353decr__y
decrypt1545703decrypt
decuries11312223decuries
decurve1335583decurve_
decurved1534843decurved
decurves1435863decurves
deedier93011593deedier
deepener1145183deepener
deeper93613503de_eper
deer56739023d___eer
deerweed1344183deerweed
defacer132810363defacer
defamer132710323defamer
defer94619753de__fer
deferrer12135593deferrer
deffer134411303de_ffer
defier105118653de_fier
defiler113911883defiler
definer114413773definer
deforcer14246903deforcer
deformer14247943deformer
defrayer1534933defrayer
defter104215923de_fter
defuser115110503defuser
degrader11247913degrader
degreaser1144333degreaser
dehorner1235523dehorner
deicer94114413de_icer
deifier113013123deifier
delayer113010533delayer
deliver113312243deliver
deluder9168333deluder
delver104913493de_lver
demerger12127373demerger
demurer1037873demurer
demurrer1144043demurrer
denier74420693de_nier
denser74115193de_nser
denuder9167603denuder
depleter11298863depleter
deporter1169393deporter
deposer104011843deposer
depraver1435413depraver
depress10239873depress
depriver1446293depriver
dere56845903de_r_e_
derider93214973derider
deriver114213913deriver
dernier83011943dernier
derriere936043derriere
derries83124623derries
describer1444613describer
descried1248073descried
descriers1245693descriers
descries11311923descries
deserter91211603deserter
deserver12118383deserver
desirer8310783desirer
destrier9311823destrier
deter65028043de__ter
deterger10147593deterger
deterrer9137013deterrer
deviser114212393deviser
dewater112912423dewater
dewier104013463de_wier
dewormer14256323dewormer
dexter143810893de_xter
dicer85426423dic__er
dicier94416233dic_ier
dicker134521403dic_ker
dickier143512453dickier
dictier103411863dictier
direr64927073d_ir_er
discreet11413183discreet
docker134417653doc_ker
dormer94415903d_ormer
dorper94314573d_orper
dorser74819183d_orser
dourer74215273dour_er
drear65016903d__rear
drearier9297923drearier
dree56638323d__ree_
dreed75222843d__reed
drees65628523d__rees
drier64423963d__rier
dryer95111463d__ryer
ducker134317993duc_ker
duckier143911793duckier
dwarfer1433683dwarfer
earner63617223_earner
echoer114011103_echoer
eerier64320023_eerier
emeer74815363_e_meer
excreter1766123excreter
fearer94820183fear_er
ferreter1136543ferreter
freer86021243__freer
hearer94323643hear_er
heckler16278573heckler
herder104516463he_rder
jeerer13389933jeer_er
jereed144012073je_reed
jerker17369043je_rker
jerreed1535213jerreed
learier73415663learier
learner7319383learner
lecher113415853lec_her
leerier73111503leerier
mercer105214203me_rcer
merer75126233me_r_er
merger95016483me_rger
merrier92612303merrier
nearer64618893near_er
necker124012793nec_ker
pearler9310373pearler
pearter9412743pearter
pecker144615363pec_ker
peckier153910523peckier
percher143313423percher
perter84422283pe_rter
pickeer153710113pickeer
rearer64928913rear_er
rebreed104611073rebreed
reciter94117263reciter
recorder11249633recorder
recover124312623recover
regreen8309043regreen
regreet83015953regreet
reorder8239483reorder
rescreen1046703rescreen
reverer103815833reverer
scree720031713_scree_
screed95718933_screed
screen85216023_screen
screes85023973_screes
screwer124410073_screwer
searer65432023sear_er
seceder10329573seceder
secrecy1444743secrecy
secret8325063secr_et
secrete9311073secrete
secreted1138633secreted
secretes10410473secretes
secretor1045683secretor
secrets9311773secrets
securer958253securer
serener73415763se_rener
serer55935513se_r_er
serger73819743se_rger
server94917713se_rver
severer103511563severer
tearer64822903tear_er
tearier73815613tearier
techier1269243techier
termer85717253te_rmer
terreen7257573terreen
terrier73414963terrier
terser67317823te_rser
veneer94511693ve_neer
verger104315703ve_rger
verier94620963ve_rier
verser94516963ve_rser
wearer94319403wear_er
wearier103613283wearier
weirder1144923weirder
yearner10336873yearner

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.420425454.8
2DLD Change Limit1340272706.72019944.5
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.23324705.0
 
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.