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

171 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
diereses93869(None) 
diaereses1045591diaereses
dieresis956851dieresis
diureses936451diureses
diaeresis1044772diaeresis
dieses75218692di__eses
digeneses1147392digeneses
digress938322digres_s
digresses1137862digresses
dioceses1137112dioceses
diuresis945132diuresis
phereses1348092phereses
ageneses939303ageneses
anureses837973anureses
aphereses1466423aphereses
biremes1138773bi_remes
birses84717733bi_r_ses
cereuses1049243_cereuses
cerises94722253_cerises
ceruses93716233_ceruses
cheeses123613103che_eses
citruses1037483citruses
creeses93914623cre_eses
cypreses1535143cypreses
debases103814133d_ebases
deceases11410153d_eceases
decreases1237223decreases
decrees102513123decre_es
defenses1237913d_efenses
defuses114814593d_efuses
degases93413103d_egases
degreases1146153degreases
degrees92810723degre_es
deixises1635693deixises
deletes83117933d_eletes
demesnes1137083d_emesnes
demises103719563d_emises
demoses103815833d_emoses
deposes103117213d_eposes
depress10239873depres_s
depresses1259883depresses
derates84028893d_erates
derbies103016053d_erbies
derides93420853d_erides
derives114017813d_erives
dermises112512023d_ermises
derries83124623d_erries
derrises93012783derrises
desexes1537833d_esexes
detests83711743d_etests
devests114410473d_evests
devises114116763d_evises
diabases1137223diabases
diabetes1147023diabetes
diageneses1245583diageneses
dialyses1236133dialyses
diapedeses1452133diapedeses
diaries83321953diar_ies
diarists9410363diarists
diatheses1345893diatheses
dickenses1645073dickenses
dienes75719903di__enes
dieretic1148763dieretic
diesel74410403di__esel
dieseled1035523dieseled
diesels8429143diese_ls
diesis74013493di__esis
diestruses1164503diestruses
dieters83216433diete_rs
diffuses1534823diffuses
digenesis1145333digenesis
digests93610613di_gests
digressed1245613digressed
dimerisms1446153dimerisms
dimerizes2167943dimerizes
dimness1038843dimnes_s
dimnesses1238213dimnesses
dinguses1037643dinguses
diocese1036853diocese_
diorites9313523diorites
diploses111110323diploses
directs102710263di_rects
direness9311303di_reness
direnesses11311483direnesses
direst75024243di_res_t
dirges84915103di_r_ges
dirties83119383di_rties
discases112014503discases
discuses113112863discuses
diseases92415813diseases
diseuses93112763diseuses
dispenses121210763dispenses
disperses121211773disperses
disposes11313823disposes
disrates91118153disrates
disrobes1139743disrobes
disseises1039333disseises
disses75225963di__sses
distress9311713distres_s
distresses1148853distresses
disuses84015413di_suses
diverges13258313diver_ges
diverse11429993diver_se_
divests114510933di_vests
divulses1244763divulses
drees65628523d__re_es
dress65319833d__res_s
dresses83716173dre_sses
druses75517253d__ruses
dueness82310123duenes_s
duenesses1039333duenesses
duress74712063d_ures_s
duresses939173duresses
editress944933editres_s
editresses1165073editresses
eisegeses1042903eisegeses
emeses86114963__emeses
enureses838113enureses
erases64425403__erases
eroses65327053__eroses
erses55826803__er_ses
exegeses1644213exegeses
fibroses1345973fibroses
geneses82613523_geneses
haeredes1246333haeredes
heiress1036813heires_s
heiresses1236963heiresses
heredes11313133_heredes
heresies11312693_heresies
hidroses1237903hidroses
hirees95117293hi_re_es
impreses1238093impreses
irises64221173_i_rises
kineses113111253ki_neses
liernes739623lier_nes
merises93421423_merises
mimeses1139073mi_meses
mirexes1636993mi_rexes
misereres1148183misereres
nemeses948663_nemeses
oversees112415903oversees
overuses11312643overuses
pareses94718883_pareses
peeress939503peeres_s
peeresses1138473peeresses
perses85428063_per_ses
peruses94018163_peruses
pheresis1377633pheresis
pierces113411193pier_ces
rerises73525883_rerises
seeress7311573seeres_s
seeresses939053seeresses
serenes73222903_serenes
siameses1036403siameses
sideroses1047353sideroses
sirees64624583si_re_es
sirrees73410573sirre_es
synereses1245313synereses
teleses7313123_teleses
tieless72512563tieles_s
tierces93710453tier_ces
tigereyes1342733tigereyes
tigress836093tigres_s
tigresses1046403tigresses
uteruses837183uteruses
verses94223763_ver_ses
viroses10310533vi_roses
viruses1039413vi_ruses
whereases1545673whereases
xeroses143612823_xeroses
xeruses143010753_xeruses

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.440406115.9
2DLD Change Limit1461621716.53022383.2
3Display Results1711710.0802137.5
 (SQL Overall)1786911717.05025346.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.