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

244 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
diseases9241581(None) 
discases112014501discases
disease83213841disease_
diseased103011711diseased
diseuses93112761diseuses
miseases102614341miseases
caseases10410472caseases
deceases11410152deceases
diabases1137222diabases
diastases1047072diastases
dieses75218692di_e_ses
discase102912862discase_
discased122510852discased
discuses113112862discuses
diseuse83110722diseuse_
dismasts1137512dismasts
dispenses121210762dispenses
disperses121211772disperses
displeases1345682displeases
disposes11313822disposes
disrates91118152disrates
dissaves1239412dissaves
disseises1039332disseises
disses75225962dis__ses
distastes1039632distastes
distaves12311402distaves
disuses84015412dis_uses
misease92713042misease_
wiseass1035822wiseas_s
wiseasses1244042wiseasses
appeases1238663appeases
asepses946363_asepses
assesses737383assesses
biases84618433bi__ases
bicepses1443873bicepses
biogases1136143biogases
boreases10310253boreases
casease939323casease_
caseates10313713caseates
caseoses1039293caseoses
ceases84427073__ceases
cineastes1165563cineastes
cineasts1045543cineasts
cistuses1038283cistuses
creases94020963_creases
danseuses1044133danseuses
deashes113313903d__eashes
deaves105319533d__eaves
debases103814133d_ebases
decease1049523decease_
deceased1247713deceased
decreases1237223decreases
defenses1237913defenses
degases93413103d_egases
degreases1146153degreases
deleaves1248063deleaves
deserves12109893deserves
desexes1537833dese_xes
despises1139433despises
diabase1037113diabase_
diaereses1045593diaereses
dialyses1236133dialyses
diapauses1244363diapauses
diastase946603diastase_
dicasts1078703di_casts
dickenses1645073dickenses
dictates11311383dictates
dienes75719903di_e_nes
diereses938693diereses
diesel74410403di_e_sel
diesels8429143di_e_sels
diesis74013493di_e_sis
diffuses1534823diffuses
digeneses1147393digeneses
digests93610613dige_sts
digresses1137863digresses
dilates83220663di_lates
dimnesses1238213dimnesses
dinettes9310193dinettes
dinguses1037643dinguses
dioceses1137113dioceses
dioecies1138933dioecies
dioptases1245903dioptases
dioxanes1645373dioxanes
diphase1387273diphase_
diploses111110323diploses
dipsades1246493dipsades
direness9311303direness
disables11410903disables
disabuses1246203disabuses
disarms1039043dis_arms
disaster949943dis_aster
disasters1039153dis_asters
disbands1237353disbands
disbars10310323disba_rs
disburses1266743disburses
discants112912023discants
discards1238913discards
discloses1249473discloses
discuss10357953discus_s
discusses12268253discusses
disdains1037913disdains
diseasing11310833diseasing
disenables1346223disenables
disengages1344343disengages
diseurs839403dise_urs
disgraces1348453disgraces
disguises1146873disguises
disgusts1045653disgusts
dishes104622653dis__hes
dishwares1645863dishwares
diskettes1446573diskettes
dislikes132810843dislikes
dismaler1137903dismaler
dismalest1246313dismalest
dismals102010243disma_ls
dismast10311233dismas_t
dismasted1346833dismasted
dismayed1535743dismayed
dismays13237433disma_ys
dismes95617673dis__mes
dismiss1038153dismis_s
dismisses1245503dismisses
disparts11109953disparts
dispense11129783dispense_
dispensed13158773dispensed
dispenser12128323dispenser
dispensers13146743dispensers
disperse111011353disperse_
dispersed13119783dispersed
disperser12109083disperser
dispersers13137423dispersers
displaces1448593displaces
displease1245523displease_
displeased1444483displeased
dispose10312763dispose_
disposed12310943disposed
disposer11310413disposer
disposers1238373disposers
dispraises1347393dispraises
disputes1139653disputes
disrate81418523disrate_
disrated10915573disrated
disrobes1139743disrobes
dissave1139413dissave_
dissaved1337313dissaved
disseated11711083disseated
disseats93211503dissea_ts
dissed85220183dis__sed
disseise939853disseise_
disseised1147863disseised
disseisee1047753disseisee
disseisees1144913disseisees
disseizes1946823disseizes
dissensus1044353dissensus
disserves1388063disserves
dissuades1166243dissuades
distaffs1565083distaffs
distains9413603distains
distances12311653distances
distaste939943distaste
distasted1137963distasted
distomes11314163distomes
distress9311713distress
distresses1148853distresses
disuse74012843dis_use_
disused93211033dis_used
disvalues1344503disvalues
disyokes1656503disyokes
diureses936453diureses
diverges13258313diverges
diverse11429993diverse_
divests114510933dive_sts
divulses1244763divulses
dosages92310803dos_ages
dosses76126273dos__ses
dresses83716173d_resses
duresses939173duresses
eases56041613___eases
eisegeses1042903eisegeses
epistases1146323epistases
feases95422923__feases
finesses111912343finesses
firebases1446583firebases
greases84816713_greases
hisses94719353his__ses
ideates8313733_ideates
idlesses936003idlesses
ileuses738673_ileuses
incases93615973_incases
jiveass1792163jiveas_s
kinases113511123ki_nases
kineses113111253kine_ses
kisses104217333kis__ses
leases65428113__leases
licenses10118923licenses
ligases82310713li_gases
limeades11116643limeades
lineages979183lineages
lipases9209483li_pases
mileages11249693mileages
mimeses1139073mime_ses
misbiases1346253misbiases
miscasts1238343miscasts
misdates111113633misdates
miseaten10310773miseaten
miseats92815783misea_ts
miseries10320403miseries
mismakes16129883mismakes
mismates121114563mismates
misnames12119883misnames
mispages13311183mispages
misparses1347653misparses
misraises1149933misraises
misrates101318243misrates
missenses1148033missenses
misses85130873mis__ses
missises103513693missises
missuses10309683missuses
mistakes141213413mistakes
misuses93216023mis_uses
obsesses1036223obsesses
peases85229473__peases
pipeages1336423pipeages
pisses84525083pis__ses
pleases94515483_pleases
releases8313343releases
risuses73210923ris_uses
seises64026713__seises
senses63923943__senses
sepses84515883__sepses
sisses64520603sis__ses
stases64225563__stases
teases65426273__teases
tisanes7311853tis_anes
tsetses785453_tsetses
uneases73316263_uneases
ureases74416723_ureases
visages1138693vis_ages
viscoses1338343viscoses
vitesses1136333vitesses
wiseacres1443393wiseacres
wiseness112010753wiseness
wisses94619603wis__ses

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.1561145455.1
2DLD Change Limit1461622448.22017781.3
3Display Results2442440.1062301.9
 (SQL Overall)1786912448.48221067.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.