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

215 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
descries1131192(None) 
decries103319801de_cries
describes1446001describes
descried1248071descried
descrier1157621descrier
descriers1245691descriers
dearies83526272de_aries
decrees102513122de_crees
decried112612852de_cried
decrier102713552de_crier
decriers11299732de_criers
decuries11312222decuries
derries83124622de_rries
describe1346242describe
described1544952described
describer1444612describer
describers1543582describers
deserves12109892deserves
desires81316132desir_es
destrier9311822destrier
destriers1038142destriers
scries85226822__scries
vestries11314052vestries
aeries64737783ae__ries
ascribes1246193_ascribes
becrimes1467073be_crimes
belfries1336983belfries
berries94423553be_rries
bescreen1244313bescreen
bescreens1343173bescreens
bestrides1237913bestrides
celeries10316313celeries
cries75438403___cries
dairies84217733d_airies
dassies84418663das_sies
dataries9314033dataries
daubries1136743daubries
deaconries1345173deaconries
deaneries10310833deaneries
dearie73319813de_arie_
debrides1268723de_brides
debrief1337623de_brief
debriefs1433533de_briefs
debris93311493de_bri_s
decades113615513de_cades
decanes103118913de_canes
decares102818533de_cares
deceits102810883de_ceits
deceives1437903de_ceives
decides114217653de_cides
deciles104417723de_ciles
deckles143312803de_ckles
declines113315803de_clines
decodes113914983de_codes
decree93117783de_cr_ee
decreed112710253de_creed
decreer10269123de_creer
decreers11277623de_creers
decrial10310323de_crial
decrials1137133de_crials
decurves1435863decurves
defies104624053de__fies
deforces14248403deforces
degrees92810723de_grees
deices94119373deic__es
deicides1249303deicides
deictics1345563deictics
deifies113317453de_ifies
deities82621923de_ities
dekares122710873dekar_es
dellies83622213de_llies
demerges12129503demerges
demerits11310763demerits
demies94825803de__mies
denarius948813denarius
dendrites1147933dendrites
denies74729643de__nies
densifies1347993densifies
densities10310793densities
deprives1438393de_prives
deputies1157533deputies
derbies103016053de_rbies
derides93420853de__rides
derives114017813de__rives
derris73615273de_rri_s
derrises93012783de_rrises
descants112910143descants
descends12266983descends
descents112511203descents
descry1256183descr__y
descrying1635103descrying
desecrates1348843desecrates
deserted101012203deserted
deserter91211603deserter
deserters10129983deserters
deserts82513053deser_ts
deserve11108703deserve_
deserved13108133deserved
deserver12118383deserver
deservers13107293deservers
desexes1537833des_exes
desire7415303desir_e_
desired9311983desir_ed
desirer8310783desir_er
desirers939263desirers
desiring10312143desiring
desirous947783desirous
desmids1166603des_mids
desmoids1244973desmoids
desorbed1236443desorbed
desorbs10437713desor_bs
despairs1144943despairs
despise1038683des_pise
despises1139433despises
despites11410313despites
despoils1145623despoils
destains9311813destains
destines93619663destines
destinies10410843destinies
destroys1236693destroys
deterges101510093deterges
deuces94015513deuc__es
devilries1345253devilries
dexies145018343de__xies
dextrines1798313dextrines
dextrins16117823dextrins
dhurries1255583dhurries
diaries83321953d_iaries
dickies143416343d_ickies
dietaries10410663dietaries
discases112014503discases
discoids1239873discoids
discreet11413183discreet
discuses113112863discuses
disprizes2148113disprizes
dories75232363d__ories
doweries12411933doweries
dowries114413983d_owries
drearies92313413drearies
dries64733673d___ries
duchies133312313d_uchies
duckies143613813d_uckies
duperies11312813duperies
durries83817353d_urries
dysurias1244463dysurias
emeries91620023_emeries
entries71523163_entries
escapes113811673_escapes
escrows1235803_escrows
eserines8413743_eserines
espies83716803_es_pies
esprits938393_esprits
estrins7315853_estrins
eucrites1049483_eucrites
eyries93816813_e_yries
ferries103521083fe_rries
fescues1236783fesc_ues
gentries91315263gentries
henries102718283he_nries
herries104025073he_rries
inscribes1345203inscribes
jerries143817513je_rries
kerries113317913ke_rries
memories121214353memories
merceries13410043merceries
mercies113817563merc_ies
mercuries1347273mercuries
miseries10320403miseries
oestrins8312673oestrins
outcries10313573outcries
pastries101517423pastries
peccaries1548533peccaries
peeries93623023pe_eries
peltries10313023peltries
penuries10311663penuries
perries93226603pe_rries
pessaries11108663pessaries
piscaries13410073piscaries
prescribes16106283prescribes
reburies10311143reburies
redescribes1652853redescribes
redries83721713re_dries
refries104419733re_fries
rescales103414573rescales
rescores105415693rescores
rescreen1046703rescreen
rescreens1144863rescreens
rescript1277423rescript
rescripts1374573rescripts
rescues9312753resc_ues
reserves111011983reserves
respires10311903respires
restrikes1339413restrikes
restrives12310663restrives
resurges9310123resurges
retries74129073re_tries
reveries112518513reveries
rosaries8312783rosaries
roseries8317313roseries
screes85023973__screes
scribes113713203__scribes
scried95817303__scried
scrims104615933__scrims
scrips105316033__scrips
scrives124414273__scrives
sentries81318053sentries
series64540973__series
serries73925353se_rries
techies12513603te_chies
terries73425633te_rries
usuries7510633_usuries
veeries102916893ve_eries
veneries112815033veneries
wastries111212883wastries
wearies103020223we_aries

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.420425454.8
2DLD Change Limit1461622157.58019282.6
3Display Results2152150.0932311.8
 (SQL Overall)1786912158.09322079.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.