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

323 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
dermises11251202(None) 
demises103719561de_mises
derrises93012781derrises
kermises14248311kermises
cercises12410932cercises
cerises94722252cer_ises
debruises1243632debruises
deixises1635692deixises
demies94825802de_mi_es
demise94618322de_mise_
demised113613682de_mised
demoses103815832de_moses
derbies103016052derbi_es
derides93420852der_ides
derives114017812der_ives
dermis94717162dermi__s
derries83124622derri_es
dervishes1644932dervishes
despises1139432despises
devises114116762de_vises
ermines9416672_ermines
merises93421422mer_ises
premises123018272premises
remises93423482re_mises
reraises8415642reraises
rerises73525882rer_ises
semises93916552se_mises
surmises10310642surmises
termites10313692termites
advertises1445913advertises
aegises8311373ae_gises
aeries64737783aer_i_es
arises65233803_ar_ises
armies85123693_armi_es
arrises71617583_arrises
atomises103514403atomises
bemires113212833be_mires
bemists113410703be_mists
bemixes18338653be_mixes
bemuses1139293be_muses
berimes115216643ber_imes
berlines102315453berlines
bermes106023003berm__es
berries94423553berri_es
besmiles1237393besmiles
betises94816123be_tises
braises93818873_braises
brewises1337213brewises
brises84927613_br_ises
bruises93212913_bruises
camises114218463_camises
carmines123617873carmines
ceramides1447453ceramides
ceramists1346723ceramists
cereuses1049243cereuses
cerise84822043cer_ise_
cerites94823433cer_ites
ceruses93716233cer_uses
cervices1537133cervices
cervixes2054603cervixes
chamises153513313chamises
chemises153211983chemises
crises84529433_cr_ises
cruises93514443_cruises
daises74318983d__aises
darbies104216983darbi_es
darkies124015753darki_es
deaminases1345283deaminases
dearies83526273deari_es
debases103814133de_bases
debrides1268723debrides
debruise1143913debruise_
debruised1343003debruised
deceases11410153deceases
deceives1437903deceives
decides114217653de_cides
deciles104417723de_ciles
declines113315803declines
decreases1237223decreases
decries103319803decri_es
defenses1237913defenses
defies104624053de_fi_es
defiles114016843de_files
defines114118683de_fines
defuses114814593de_fuses
degases93413103de_gases
degasses10278363degasses
degreases1146153degreases
dehisces1464713de_hisces
deices94119373de__ices
deicides1249303deicides
deifies113317453deifi_es
deisms94411043de__isms
deists74916433de__ists
deities82621923deiti_es
delaines9312963delaines
delimes10314193de_limes
delists84414173de_lists
dellies83622213delli_es
delouses9310013delouses
demasts1089223de_masts
demes86032693de_m__es
demesnes1137083de_mesnes
demirep1236213de_mirep
demireps1343993de_mireps
demister11310223de_mister
demisters1249203de_misters
demits94918073de_mi_ts
demonises12311093demonises
demotes104717673de_motes
denies74729643de_ni_es
dentines93418403dentines
dentists939263dentists
deposes103117213de_poses
depresses1259883depresses
deprives1438393deprives
depsides1238503depsides
deraigns1034883deraigns
derailed102410403derailed
derails84216393derai_ls
deranges1039973deranges
derates84028893der_ates
deride84420033der_ide_
derided102914253der_ided
derider93214973der_ider
deriders102411853der_iders
derive103817043der_ive_
derived123912763der_ived
deriver114213913der_iver
derivers123811363der_ivers
dermas94116813derm__as
dermatoses1344963dermatoses
dermic114511913dermi__c
dermoids1246163dermoids
derms85022893derm___s
dernier83011943derni_er
derricks1544433derricks
derrieres1044813derrieres
derris73615273derri__s
dervish1436983dervis_h
desires81316133de_sires
desists83611723de_sists
desmids1166603desmi_ds
despise1038683despise_
despised1236923despised
despiser1136343despiser
despisers1245153despisers
despites11410313despites
destines93619663destines
determines1358433determines
devices133212583de_vices
devise104215753de_vise_
devised123712563de_vised
devisee113812713de_visee
devisees12358283de_visees
deviser114212393de_viser
devisers12339863de_visers
devoices14307413devoices
dexies145018343de_xi_es
diamides1238823diamides
diamines11311643diamines
diereses938693dier_eses
dirties83119383dirti_es
dismiss1038153dismis_s
dismisses1245503dismisses
domines102918973d_omines
dories75232363dor_i_es
dormice1237133dormice_
dormie9312623dormi_e_
dormins10311273dormi_ns
dresses83716173d_resses
dries64733673d_r_i_es
drives105117113d_r_ives
drosses84513823d_rosses
drowses114610233d_rowses
druses75517253d_r_uses
dummies123012133dummi_es
duresses939173duresses
durmasts1144093durmasts
durries83817353durri_es
egises7312493_e_gises
emeses86114963_e_meses
energises1047063energises
epidermises1652503epidermises
erases64425403_er_ases
eremites10312603_eremites
ermine8416923_ermine_
ermined10410603_ermined
eroses65327053_er_oses
erses55826803_er__ses
eternises9119453eternises
excises1638933_excises
exercises1846463exercises
exodermises2152623exodermises
ferlies103216693ferli_es
fermions1336203fermions
fermis114313503fermi__s
fermiums1544353fermiums
ferries103521083ferri_es
ferrites112312833ferrites
fraises104215693_fraises
frises94124273_fr_ises
genoises939253genoises
germier10309543germi_er
germiest11249923germiest
germiness1257693germiness
harmines132715143harmines
heresies11312693heresies
hermits12312143hermi_ts
heroines112916573heroines
heroisms1338693heroisms
heroizes202610983heroizes
herries104025073herri_es
idealises1047783idealises
irises64221173_ir_ises
itemises1087693itemises
jemmies18318333jemmi_es
jerkies183411583jerki_es
jerries143817513jerri_es
kermes124616133kerm__es
kermess13396223kermes_s
kermesse14303483kermesse
kermesses15284963kermesses
kermis124012393kermi__s
kernites1269113kernites
kerries113317913kerri_es
koumises1444593koumises
krises105016083_kr_ises
lewises1039133le_wises
lorises73918593lor_ises
marmites122212793marmites
mercies113817563merci_es
merisis93213173mer_isis
mises74740563___mises
modernises1344733modernises
morrises10711073morrises
mortises10713613mortises
nemeses948663ne_meses
nereides938503nereides
nervines112310463nervines
orrises71312233_orrises
overmines14312683overmines
overmixes2137323overmixes
parises94827183par_ises
parvises133911913parvises
peises84125043pe__ises
pelvises1337273pelvises
penises9318193pe_nises
perfuses1358663perfuses
perishes13313753per_ishes
perlites10316363perlites
permeases1347103permeases
permits11314003permi_ts
permutes1238713permutes
perries93226603perri_es
perses85428063per__ses
persists1049183persists
peruses94018163per_uses
praises94121103_praises
precises123218333precises
premies113823063premi_es
premise113818553premise_
premised133013193premised
premiss113513813premis_s
premisses13288763premisses
premixes193110083premixes
previses133814283previses
prises84133173_pr_ises
promises122916763promises
raises64826543__raises
realises82420183realises
remiges103015473re_miges
remise84221953re_mise_
remised103516843re_mised
remiss84216353re_mis_s
remixes164313873re_mixes
reprises102615463reprises
reraise7316313reraise_
reraised9312353reraised
rerise64325633rer_ise_
rerisen73613643rer_isen
revises104220533re_vises
rises55244043__r_ises
seises64026713se__ises
semioses10611013se_mioses
series64540973ser_i_es
serines74229543ser_ines
serries73925353serri_es
services1338573services
sherrises12156863sherrises
spermines13310543spermines
surmise9311083surmise_
surmised1136863surmised
surmiser1036763surmiser
surmisers1145203surmisers
tamises92715973_tamises
tennises82810133tennises
tergites9310543tergites
terminus1037393terminus
terminuses1244063terminuses
termite9313893termite_
termless1036233termless
termtimes1354803termtimes
terrases82111483terrases
terries73425633terri_es
terrines82117553terrines
thermites1438043thermites
thermoses1447973thermoses
undermines131710663undermines
upraises10188473upraises
uprises92012733upr_ises
verbiles1338923verbiles
verisms123011253ver_isms
verists103613673ver_ists
verites103822263ver_ites
vermes115019143verm__es
vermis114214963vermi__s
vernixes1836053vernixes
verses94223763ver__ses
versines112213823versines
vertices13612283vertices
xeroses143612823xer_oses
xeruses143010753xer_uses

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.420425454.8
2DLD Change Limit1461623236.51622431.2
3Display Results3233230.1262563.5
 (SQL Overall)1786913237.06225303.2
 
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.