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

220 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
deciares1151063(None) 
decares102818531dec_ares
deciare10710661deciare_
declares11611311declares
decades113615512dec_ades
decanes103118912dec_anes
decare93919152dec_are_
deceases11410152deceases
deciders123510752deciders
decides114217652deci_des
deciles104417722deci_les
decimates14410692decimates
declare10411222declare_
declared1248742declared
declarer1148062declarer
declarers1236422declarers
dekares122710872de_kares
desires81316132desi_res
deviates12312732deviates
hectares1338852hectares
becharms1745343becharms
bemires113212833bemi_res
bewares12313373be_wares
cares77369183__c_ares
caviares1337993caviares
cecities12312043cecities
centares102913893centares
centiares1167653centiares
chares115631803__chares
cires74932913__ci_res
dacites101114593daci_tes
dares66146703d___ares
daycares1454803daycares
daymares1445333daymares
deaired9411533deai_red
deairs74013783deai_r_s
dealates92716683dealates
dearer74822803de__arer
dearest83618673de__arest
dearies83526273de__aries
dears65736883de__ar_s
deaves105319533de__aves
debarks14388493de_barks
debars94218043de_bar_s
debases103814133de_bases
debates103718533de_bates
debeards1235503debeards
decade104216163dec_ade_
decafs124010883dec_a_fs
decals93717713dec_a_ls
decamps1435643dec_amps
decane93818873dec_ane_
decants103514443dec_ants
decayed14309333dec_ayed
decayer13339353dec_ayer
decayers14307963dec_ayers
decays124612913dec_a_ys
decease1049523decease_
deceased1247713deceased
deceivers1535723deceivers
deceives1437903deceives
decenaries1348123decenaries
decentres12238523decentres
decerns10119053dec_erns
decibel1235993deci_bel
decibels1344523decibels
decide104116873deci_de_
decided124312423deci_ded
decider114213183deci_der
deciduas1243463deciduas
decigram1445353decigram
decigrams1544093decigrams
decile94619213deci_le_
decilitres1344993decilitres
decimals1345863decimals
decimate13411123decimate_
decimated1548953decimated
decimetres15135043decimetres
decipher1644423decipher
deciphers1744393deciphers
deckers144413833decker_s
deckles143312803dec_kles
declaims1345823declaims
declass1038733decla_ss
declasse1165943declasse
declasses1246443declasses
declawed1545923declawed
declaws1336253decla_ws
decliners12358613decliners
declines113315803declines
decoders122810413decoders
decodes113914983dec_odes
decorates12314743decorates
decors94017773dec_or_s
decoyers14287713decoyers
decreases1237223decreases
decree93117783dec__ree
decreers11277623decreers
decrees102513123dec_rees
decrials1137133decria_ls
decriers11299733decrier_s
decries103319803dec_ries
decuples1395283decuples
decuries11312223decuries
decurves1435863decurves
dedicates13311693dedicates
defaces133213403de_faces
defames132812253de_fames
defiances1557033defiances
defiers113913993defier_s
defies104624053defi__es
defilades14134073defilades
defilers12439473defilers
defiles114016843defi_les
definers124211193definers
defines114118683defi_nes
deflates123013943deflates
degames113312623de_games
degases93413103de_gases
deglazes1935463deglazes
degrades11269923degrades
dehisces1464713dehisces
deicers103612733deicer_s
deices94119373de_i_ces
deicides1249303deicides
deifies113317453de_ifies
deities82621923de_ities
dekare112811563de_kare_
delaines9312963delaines
delates83526283de_lates
deleaves1248063deleaves
delicates12314313delicates
delimes10314193deli_mes
delivers123310753delivers
demarks14339233de_marks
demies94825803demi__es
demirep1236213demi_rep
demireps1343993demi_reps
demises103719563demi_ses
demiurges1343863demiurges
denars74621433de_nar_s
denials84114133denia_ls
deniers84515183denier_s
denies74729643deni__es
dentures9312453dentures
deodaras1044693deodaras
deodars937623deodar_s
departs104310683de_parts
depilates12310923depilates
deplanes11311213deplanes
deplores1139533deplores
depraves1436873depraves
derates84028893de_rates
deriders102411853deriders
derides93420853deri_des
derivates13310093derivates
derivers123811363derivers
derives114017813deri_ves
derrieres1044813derrieres
desire7415303desi_re_
desired9311983desi_red
desirer8310783desi_rer
desirers939263desi_rers
detinues9569823detinues
deviances1566493deviances
deviants1236733deviants
deviate11312713deviate_
deviated13311043deviated
devices133212583devi_ces
devilries1345253devilries
devisees12358283devisees
devisers12339863devisers
devises114116763devi_ses
dewars105117073de_war_s
dewaxes18297843de_waxes
dexies145018343dexi__es
diaries83321953d__iaries
dictates11311383dictates
dockages1635983dockages
ecartes94212563_ec_artes
echards1337963_echards
ectases92911673_ectases
emigres1037673_emigres
fecials123510333fecia_ls
fetiales11319613fetiales
hectare1238463hectare_
hektares1535813hektares
lectures101310153lectures
mediates112814063mediates
medicares1446873medicares
nectaries1149813nectaries
nectars938463nectar_s
peccaries1548533peccaries
pectases122411193pectases
pectates122213953pectates
recanes93222263rec_anes
recharges1586953recharges
recharts1337663recharts
recipes113314463reci_pes
reciters102613113reciters
recites93524583reci_tes
reclames12310893reclames
recrates102420373recrates
redwares1239053redwares
refires104820313refi_res
rehires105016113rehi_res
retires74726213reti_res
rewires104717113rewi_res
scares85033003_sc_ares
seawares1139333seawares
secpars1138413secpar_s
sectaries11312243sectaries
secures9613163sec_ures
seriates82620673seriates
speciates13229233speciates
teawares1148083teawares
teniases838623teniases
venires103012453veni_res
welfares1445543welfares
wetwares1445953wetwares

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622207.96618348.2
3Display Results2202200.0802750.0
 (SQL Overall)1786912208.48221067.1
 
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.