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

241 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
decuries1131222(None) 
decries103319811dec_ries
decurves1435861decurves
becurses1236722becurses
curies84934022__curies
dearies83526272de_aries
decares102818532decar_es
decrees102513122dec_rees
decried112612862dec_ried
decrier102713562dec_rier
decriers11299732dec_riers
decuples1395282decuples
decurion1146622decurion
decurions1246022decurions
decurve1335582decurve_
decurved1534842decurved
deputies1157532deputies
derries83124622de_rries
descries11311922descries
mercuries1347272mercuries
penuries10311662penuries
reburies10311142reburies
recurves1337402recurves
secures9613162secur_es
aeries64737783ae__ries
auguries947933auguries
beauties10229523beauties
becrimes1467073bec_rimes
becurse1136183becurse_
becursed1335593becursed
belfries1336983belfries
berries94423553be_rries
buries84633273__buries
caries85147623__caries
cecities12312043cecities
celeries10316313celeries
centuries11311333centuries
cries75438403__c_ries
cures75645433__cur_es
curie74533043__curie_
curios83218333__curios
curites93919863__curites
curries93723163__curries
curses85328273__curses
curves114619283__curves
cuties84927363__cuties
dairies84217733d_airies
dataries9314033dataries
daubries1136743daubries
dauties83315763d_auties
deaconries1345173deaconries
deaneries10310833deaneries
dearie73319813de_arie_
debrides1268723de_brides
debrief1337623de_brief
debriefs1433533de_briefs
debris93311493de_bri_s
debruise1143913debruise
debruises1243633debruises
decades113615513dec_ades
decanes103118913dec_anes
decare93919153decar_e_
deceases11410153deceases
deceits102810883dec_eits
deceives1437903deceives
decenaries1348123decenaries
decencies1448943decencies
decerned1237263decerned
decerns10119053decer_ns
deciares11510633deciares
decides114217653dec_ides
deciles104417723dec_iles
deckles143312803dec_kles
declaims1345823declaims
declares11611323declares
declines113315803declines
decodes113914983dec_odes
decorates12314743decorates
decorous1138853decorous
decors94017773decor__s
decorums1344993decorums
decouples14104943decouples
decree93117783dec_r_ee
decreed112710263dec_reed
decreer10269123dec_reer
decreers11277623dec_reers
decrial10310323dec_rial
decrials1137133dec_rials
decuple1285363decuple_
decupled1494993decupled
decurrent1256453decurrent
decurving1634723decurving
decury1277963decur__y
deduces1168793dedu_ces
defies104624053de__fies
deforces14248403deforces
defuses114814593defu_ses
defuzes20398303defu_zes
degrees92810723de_grees
deifies113317453de_ifies
deities82621923de_ities
dekares122710873dekar_es
dellies83622213de_llies
deludes91810643delu_des
deluges9169263delu_ges
demerges12129503demerges
demerits11310763demerits
demies94825803de__mies
demiurges1343873demiurges
demure9311533demur_e_
demurer1037873demur_er
demurest1137453demur_est
demurred1234933demurred
demurrer1144043demurrer
demurrers1243713demurrers
demurs939773demur__s
denarius948813denarius
dendrites1147933dendrites
denies74729643de__nies
dentures9312453dentur_es
denudes91510043denu_des
deprives1438393de_prives
depurates1239823depurates
deputes104911783depu_tes
deputizes2144983deputizes
derbies103016053de_rbies
derides93420853de__rides
derives114017813de__rives
derris73615273de_rri_s
derrises93012783de_rrises
describes1446003describes
descried1248083descried
descrier1157623descrier
descriers1245693descriers
deserves12109893deserves
desires81316133desir_es
destrier9311823destrier
destriers1038143destriers
deterges101510093deterges
detrudes1036203detrudes
deuces94015513de_u_ces
devilries1345253devilries
dexies145018343de__xies
dextrines1798313dextrines
dextrins16117823dextrins
dhurries1255583dhurries
diaries83321953d_iaries
dickies143416343dic_kies
dietaries10410663dietaries
doctrines1247153doctrines
dories75232363d__ories
dourines9311373d_ourines
doweries12411933doweries
dowries114413983d_owries
drearies92313413drearies
dries64733673d___ries
duchies133312313duc_hies
duckies143613813duc_kies
duperies11312813duperies
dures65635923d__ur_es
durries83817353d_urries
duties74921903d__uties
dysurias1244463dysurias
ecartes94212563_ecartes
emeries91620023_emeries
entries71523163_entries
enures63919713_enur_es
eucrites1049483_eucrites
eyries93816813_e_yries
ferries103521083fe_rries
furies95126373__furies
gentries91315273gentries
henries102718283he_nries
herries104025083he_rries
incurves1336393incurves
injuries1567683injuries
jerries143817513je_rries
juries134120633__juries
kauries113613193_kauries
kerries113317913ke_rries
lecheries1449073lecheries
lectures101310163lectur_es
lemures938793lemur_es
luxuries1544793luxuries
memories121214353memories
merceries13410043merceries
neckties1445913neckties
nectaries1149823nectaries
neurines8311193ne_urines
occupies1444223occupies
peccaries1548533peccaries
peeries93623023pe_eries
peltries10313023peltries
perjuries1846493perjuries
perries93226603pe_rries
precures12312903precur_es
reburied1137913reburied
recarries1147873recarries
recopies12313743recopies
recourses1137733recourses
recruits1036563recruits
rectories11314663rectories
rectrices1338873rectrices
recurred1137093recurred
recurs83315803recur__s
recurve1237403recurve_
recurved1436493recurved
recuses94619463recu_ses
redries83721713re_dries
refries104419733re_fries
requires17168703requires
resurges9310123resurges
retries74129073re_tries
reveries112518513reveries
sauries72821623_sauries
scries85226823_sc_ries
scurries102911483_scurries
scurvies13248123_scurvies
sectaries11312243sectaries
secure8513533secur_e_
secured1059723secur_ed
securer958253secur_er
securers1057153securers
securest1058583secur_est
securing11310413securing
securities1248553securities
security1346693security
sentries81318063sentries
series64540973se__ries
serries73925353se_rries
techies12513603tec_hies
tectrices1346253tectrices
tenures7412013tenur_es
terries73425633te_rries
upcurves1583153upcurves
usuries7510633_usuries
veeries102916893ve_eries
velures1039093velur_es
veneries112815033veneries
vestries11314053vestries
wearies103020233we_aries

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622416.97020970.2
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.46623934.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.