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

343 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
derrises9301278(None) 
dermises112512021dermises
derries83124621derri_es
arrises71617582_arrises
berries94423552berri_es
cercises12410932cercises
cerises94722252ce_rises
dearies83526272deari_es
debrides1268722debrides
debruises1243632debruises
decries103319802decri_es
deixises1635692deixises
demises103719562de_mises
deprives1438392deprives
derbies103016052derbi_es
derides93420852de_rides
derives114017812de_rives
derricks1544432derricks
derrieres1044812derrieres
derris73615272derri__s
dervishes1644932dervishes
despises1139432despises
devises114116762de_vises
durries83817352durri_es
ferries103521082ferri_es
ferrites112312832ferrites
herries104025072herri_es
jerries143817512jerri_es
kermises14248312kermises
kerries113317912kerri_es
merises93421422me_rises
morrises10711072morrises
orrises71312232_orrises
perries93226602perri_es
reprises102615462reprises
reraises8415642reraises
rerises73525882re_rises
serries73925352serri_es
sherrises12156862sherrises
terrases82111482terrases
terries73425632terri_es
terrines82117552terrines
advertises1445913advertises
aegises8311373ae_gises
aeries64737783ae_ri_es
apprises12310963apprises
arises65233803__arises
arrases71214543_arrases
arrives101311513_arrives
becrimes1467073becrimes
begrimes1376513begrimes
berberises1444903berberises
berimes115216643be_rimes
berlines102315453berlines
berried103714043berri_ed
betises94816123be_tises
braises93818873_braises
brewises1337213brewises
brises84927613__brises
bruises93212913_bruises
carries94328013carri_es
cereuses1049243cereuses
cerise84822043ce_rise_
cerites94823433ce_rites
ceruses93716233ce_ruses
cervices1537133cervices
cervixes2054603cervixes
cherries131812983cherri_es
corries94026793corri_es
crises84529433__crises
cruises93514443_cruises
curries93723163curri_es
dairies84217733dairi_es
daises74318983d__aises
darbies104216983darbi_es
darkies124015753darki_es
dearie73319813deari_e_
dearness939973dearness
debases103814133de_bases
debride1138593debride_
debrided1336583debrided
debrief1337623debri_ef
debriefs1433533debriefs
debris93311493debri__s
debruise1143913debruise_
debruised1343003debruised
deceases11410153deceases
deceives1437903deceives
decides114217653de_cides
deciles104417723de_ciles
declines113315803declines
decreases1237223decreases
decrees102513123decr_ees
decrials1137133decrials
decried112612853decri_ed
decrier102713553decri_er
decriers11299733decriers
decuries11312223decuri_es
defenses1237913defenses
defies104624053de_fi_es
defiles114016843de_files
defines114118683de_fines
defrosts1244833defrosts
defuses114814593de_fuses
degases93413103de_gases
degasses10278363degasses
degrades11269923degrades
degreases1146153degreases
degrees92810723degr_ees
dehisces1464713de_hisces
deices94119373de__ices
deicides1249303deicides
deifies113317453deifi_es
deisms94411043de__isms
deists74916433de__ists
deities82621923deiti_es
delaines9312963delaines
delimes10314193de_limes
delists84414173de_lists
dellies83622213delli_es
delouses9310013delouses
demies94825803de_mi_es
demise94618323de_mise_
demised113613683de_mised
demonises12311093demonises
demoses103815823de_moses
dendrites1147933dendrites
denies74729643de_ni_es
dentines93418403dentines
dentists939263dentists
deposes103117213de_poses
depraves1436873depraves
depress10239873depres_s
depresses1259883depresses
deprive1338303deprive_
deprived1546463deprived
depriver1446293depriver
deprivers1545213deprivers
depsides1238503depsides
deraigns1034883deraigns
derailed102410403derailed
derails84216393derai_ls
deranges1039973deranges
derates84028893de_rates
deride84420033de_ride_
derided102914253de_rided
derider93214973de_rider
deriders102411853de_riders
derive103817043de_rive_
derived123912763de_rived
deriver114213913de_river
derivers123811363de_rivers
dermis94717163dermi__s
dernier83011943derni_er
derrick1435803derri_ck
derriere936043derriere
derringer1144593derringer
derringers1243843derringers
dervish1436983dervis_h
describes1446003describes
descries11311923descri_es
desires81316133de_sires
desists83611723de_sists
despise1038683despise_
despised1236923despised
despiser1136343despiser
despisers1245153despisers
despites11410313despites
destines93619663destines
detritus945473detritus
detrudes1036203detrudes
devices133212583de_vices
devise104215753de_vise_
devised123712563de_vised
devisee113812713de_visee
devisees12358283de_visees
deviser114212393de_viser
devisers12339863de_visers
devoices14307413devoices
dexies145018343de_xi_es
dextrines1798313dextrines
dextroses1745663dextroses
dhurries1255583dhurri_es
diaries83321953diari_es
diarists9410363diarists
diereses938693diereses
diorites9313523diorites
dirties83119383dirti_es
diureses936453diureses
dories75232363d_ori_es
dourines9311373dourines
dowries114413983dowri_es
drearies92313413dreari_es
dresses83716173d_resses
dries64733673d__ri_es
drives105117113d__rives
drosses84513823d_rosses
drowses114610233d_rowses
druses75517253d__ruses
duresses939173duresses
durrie73713263durri_e_
egises7312493_e_gises
emprises12311003emprises
energises1047063energises
erases64425403_e_rases
ermines9416673_ermines
eroses65327053_e_roses
errhines1136413_errhines
erses55826803_e_r_ses
eternises9119453eternises
excises1638933_excises
exercises1846463exercises
eyries93816813_eyri_es
ferlies103216693ferli_es
ferrates113013423ferrates
ferriages1345663ferriages
ferried113411523ferri_ed
ferrite103312753ferrite_
ferrules1136163ferrules
fraises104215693_fraises
frises94124273__frises
genoises939253genoises
gurries83515953gurri_es
harries103525493harri_es
hearses104414533hear_ses
henries102718283henri_es
heresies11312693heresies
heroines112916573heroines
heroisms1338693heroisms
heroizes202610983heroizes
herried113514453herri_ed
herrings12379533herrings
hubrises1337103hubrises
hurries103919653hurri_es
hybrises1645423hybrises
idealises1047783idealises
irises64221173__irises
jerkies183411583jerki_es
jerrids15277743jerri_ds
kernites1269113kernites
kerrias11289513kerri_as
krises105016083__krises
lewises1039133le_wises
lorises73918593_lorises
lorries74518343lorri_es
marries93825283marri_es
memorises131211583memorises
mercerises1446193mercerises
mercies113817563merci_es
merisis93213173me_risis
merrier92612303merri_er
merriest10311473merriest
merriness1138293merriness
metrists1039853metrists
modernises1344733modernises
mortises10713613mortises
murries94118673murri_es
necroses10310563necroses
nereides938503nereides
nervines112310463nervines
neurines8311193neurines
neuroses8310153neuroses
orrices9129363_orrices
overrides131411013overrides
parises94827183_parises
parries93925843parri_es
parvises133911913parvises
peeries93623023peeri_es
peises84125043pe__ises
pelvises1337273pelvises
penises9318193pe_nises
perfuses1358663perfuses
perishes13313753pe_rishes
perlites10316363perlites
perses85428063pe_r_ses
persists1049183persists
peruses94018163pe_ruses
praises94121103_praises
precises123218333precises
premises123018273premises
prerinses1138813prerinses
previses133814283previses
prises84133173__prises
raises64826543__raises
realises82420183realises
redries83721713redri_es
redrives122610393redrives
refries104419733refri_es
remises93423483re_mises
reprices122913353reprices
reprise92715043reprise_
reprised112012203reprised
reraise7316313reraise_
reraised9312353reraised
rerise64325633re_rise_
rerisen73613643re_risen
retries74129073retri_es
revises104220533re_vises
rewrites11311063rewrites
rises55244043___rises
seises64026713se__ises
semises93916553se_mises
series64540973se_ri_es
serines74229543se_rines
serrates82617023serrates
serried82513963serri_ed
services1338573services
sherries111812893sherri_es
skerries12168673skerri_es
sunrises8310693sunrises
surmises10310643surmises
surprises1137433surprises
tarries73324263tarri_es
tennises82810133tennises
tergites9310543tergites
termites10313693termites
terraces102712253terraces
terranes82514433terranes
terrenes82212603terrenes
terrier73414963terri_er
terriers84210823terriers
terrifies12139723terrifies
terrine72517573terrine_
territs72714503terri_ts
terrorises1087423terrorises
theorises1247813theorises
upraises10188473upraises
uprises92012733_uprises
veeries102916893veeri_es
verbiles1338923verbiles
verisms123011253ve_risms
verists103613673ve_rists
verites103822263ve_rites
vernixes1836053vernixes
verses94223763ve_r_ses
versines112213823versines
vertices13612283vertices
wearies103020223weari_es
wherries14179023wherri_es
worries104117133worri_es
xeroses143612823xe_roses
xeruses143010753xe_ruses
zebrines1935883zebrines

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.406440125.6
2DLD Change Limit1461623437.73318901.1
3Display Results3433430.1402450.0
 (SQL Overall)1786913438.27921583.6
 
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.