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

123 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
diureses93645(None) 
diereses938691diereses
diuresis945131diuresis
anureses837972anureses
diaereses1045592diaereses
dieresis956852dieresis
dieses75218692di__eses
digress938322digres_s
digresses1137862digresses
dioceses1137112dioceses
duress74712062d_ures_s
duresses939172d_uresses
enureses838112enureses
anuresis846963anuresis
auxeses1435623_auxeses
biremes1138773bi_remes
birses84717733bi_r_ses
bourses94014303bour_ses
burses84425513_bur_ses
citruses1037483citruses
courses94218893cour_ses
curses85328273_cur_ses
cypreses1535143cypreses
decreases1237233decreases
decrees102513123decre_es
degreases1146153degreases
degrees92810723degre_es
depress10239873depres_s
depresses1259883depresses
derrises93012783derrises
dhurries1255583dhurries
diabases1137223diabases
diabetes1147023diabetes
diaeresis1044773diaeresis
dialyses1236133dialyses
diaries83321953diar_ies
diarists9410363diarists
diatheses1345893diatheses
dickenses1645073dickenses
dienes75719903di__enes
diesel74410403di__esel
diesels8429143di__esels
diesis74013493di__esis
diffuses1534833diffuses
digeneses1147393digeneses
digests93610613di_gests
digressed1245613digressed
dimness1038843dimnes_s
dimnesses1238213dimnesses
dinguses1037643dinguses
diocese1036853diocese_
diorites9313523diorites
diploses111110323diploses
directs102710263di_rects
direness9311303di_reness
direst75024243di_res_t
dirges84915103di_r_ges
dirties83119383di_rties
disburses1266743disbur_ses
discases112014503discases
discuses113112863discuses
diseases92415813diseases
diseuses93112763diseuses
dispenses121210763dispenses
disperses121211773disperses
disposes11313823disposes
disrates91118153disrates
disrobes1139743disrobes
disseises1039333disseises
disses75225963di__sses
distress9311713distres_s
distresses1148853distresses
disuses84015413di_suses
diuretic1146993diuretic
diuretics1244953diuretics
diurnals943803diurnals
diurons838823diur_ons
diverges13258313diverges
diverse11429993diverse_
divests114510933di_vests
divulses1244763divulses
dourest8312943doures_t
dourines9311373dourines
dourness947683dournes_s
dournesses1138243dournesses
douses74928933dou__ses
drees65628523d__re_es
dress65319833d__res_s
dresses83716173d__resses
druses75517253d__ruses
dufuses11436593d_ufuses
dulses73913653d_u_lses
dures65635923d_ur__es
durries83817353d_urries
editress944933editres_s
editresses1165073editresses
enuresis845493enuresis
fibroses1345983fibroses
hidroses1237903hidroses
hirees95117293hi_re_es
impreses1238093impreses
irises64221173_i_rises
kineses113111253ki_neses
lurexes1436073_lurexes
mimeses1139073mi_meses
mirexes1636993mi_rexes
murexes1636973_murexes
neuroses8310163neuroses
nurses63919353_nur_ses
pareses94718883_pareses
phereses1348093phereses
purees84721683_pure_es
purses84826373_pur_ses
siameses1036403siameses
sirees64624583si_re_es
sirrees73410573sirre_es
tigress836093tigres_s
tigresses1046403tigresses
urases63723563__urases
ureases74416723__ureases
uruses63616503__uruses
viroses10310533vi_roses
viruses1039413vi_ruses

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.406440125.6
2DLD Change Limit1461621236.53022383.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.98225593.1
 
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.