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

108 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
dioceses113711(None) 
diocese1036851diocese_
diereses938692diereses
dieses75218692di__eses
diocesan1142912diocesan
diocesans1242482diocesans
dioecies1138932dioecies
discases112014502discases
discuses113112862discuses
diureses936452diureses
adipoceres1552063adipoceres
asceses938623_asceses
bicepses1443873bi_cepses
biocenoses1443973biocenoses
biocides1336933biocides
biogases1136143biogases
biolyses1345573biolyses
circuses1238253circuses
crocuses1239023crocuses
deceases11410153d_eceases
defocuses15134493defocuses
diabases1137223diabases
diabetes1147023diabetes
diaereses1045593diaereses
dialyses1236133dialyses
diatheses1345893diatheses
dicasts1078703di_casts
dicers94720743di_ce_rs
dices86434243di_c__es
dickenses1645073dickenses
dickies143416343di_ckies
dienes75719903di__enes
dieresis956853dieresis
diesel74410403di__esel
diesels8429143di__esels
diesis74013493di__esis
diffuses1534823diffuses
digeneses1147393digeneses
digests93610613di_gests
digress938323digres_s
digresses1137863digresses
dimness1038843dimnes_s
dimnesses1238213dimnesses
dinguses1037643dinguses
diodes83915783dio__des
dioecisms1444353dioecisms
dioptases1245903dioptases
dioptres1146113dioptres
diorites9313523diorites
dioxanes1645373dioxanes
dioxides1756203dioxides
diploses111110323diploses
discase102912863discase_
discased122510853discased
discepts1336743discepts
discerns1138163discerns
discloses1249473discloses
discuss10357953discus_s
discusses12268253discusses
diseases92415813diseases
diseuses93112763diseuses
dispenses121210763dispenses
disperses121211773disperses
disposes11313823disposes
disseises1039333disseises
disses75225963di__sses
disuses84015413di_suses
ditches133215713ditc_hes
diuresis945133diuresis
divests114510933di_vests
divorcees1543333divorce_es
divulses1244763divulses
docents102810803d_ocents
donees74519493d_one_es
doofuses1244283doofuses
doolees83711613doole_es
doses65938503d_o__ses
dosses76126273d_o_sses
douses74928933d_o_uses
dowses105718303d_o_wses
drosses84513823dro_sses
drowses114610233dro_wses
ficuses12159203fi_cuses
focuses12159653_focuses
hocuses121710423_hocuses
idiocies1145223idioc_ies
idocrases1273793idocrases
idolises938763idolises
incases93615973_incases
incenses102411003_incenses
incests92711383_incests
incises93414893_incises
incuses93514853_incuses
iodises83413633_iodises
ionises72916433_ionises
joneses1438963_joneses
kineses113111253ki_neses
licenses10118923li_censes
lioness739103liones_s
lionesses939433lionesses
lionises8310313lionises
mimeses1139073mi_meses
miocene1147923miocene_
mioses84318853mio__ses
process11310403proces_s
processes13310233processes
siameses1036403siameses
viscoses1338343viscoses

Search took 7 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.423422437.4
2DLD Change Limit1461621086.47022590.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.93925751.7
 
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.