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

253 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
disease8321384(None) 
discase102912861discase
diseased103011711diseased
diseases92415811diseases
diseuse83110721diseuse
misease92713041misease
casease939322casease
decease1049522decease
diabase1037112diabase
diastase946602diastase
diphase1387272diphase
discased122510852discased
discases112014502discases
diseuses93112762diseuses
dismast10311232dismast
dispense11129782dispense
disperse111011352disperse
displease1245522displease
dispose10312762dispose
disrate81418522disrate
dissave1139412dissave
disseise939852disseise
distaste939942distaste
disuse74012842dis_use
diverse11429992diverse
miseases102614342miseases
wiseass1035822wiseass
appease1137913appease
bises75435623bise_s_
bistate9313823bistate
caseases10410473caseases
caseate9314783caseate
caseose939163caseose
cease75227653__cease
cineast9310523cineast
cineaste1045743cineaste
crease85519573_crease
daises74318983daise_s_
danseuse942893danseuse
deash95617243d__eash
deave95022333d__eave
debase94014473d_ebase
deceased1247713deceased
deceases11410153deceases
decrease1136563decrease
defense1137503defense
degrease1045413degrease
deleave1147723deleave
dense65923503d__ense
deserve11108703deserve
desexes1537833desexes
despise1038683despise
diabases1137223diabases
dialyse1135463dialyse
diapause1143893diapause
diastases1047073diastases
dicast9315573di_cast
dicers94720743dicers_
dices86434243dice_s_
dictate10311663dictate
diene65720133di_e_ne
dienes75719903di_enes
dies55653523di_e_s_
diesel74410403di_e_sel
diesels8429143diesels_
dieses75218693di_e_ses
diesis74013493diesis_
diets66026643di_ets_
diffuse1444373diffuse
digest84019623dige_st
dikers114418793dikers_
dikes105831333dike_s_
dilate73220693di_late
dimers94321093dimers_
dimes85833043dime_s_
diners75525953diners_
dines66449153dine_s_
dinette8310013dinette
diocese1036853diocese
dioptase1145513dioptase
dioxane1565423dioxane
dipsas9359893dipsas_
direst75024243dire_st
disable10516433disable
disabuse1145553disabuse
disarm9310473dis_arm
disaster949943dis_aster
disband1138243disband
disbar938513disba_r
disbars10310323disbars
disburse1186443disburse
discant103017253discant
discard11310213discard
disclose1148743disclose
discos94915213discos_
discs85316263dis_cs_
discus94512113discus_
discuses113112863discuses
discuss10357953discuss
disdain938513disdain
diseasing11310833diseasing
disenable1249663disenable
disengage1243873disengage
diseur738843dise_ur
diseurs839403diseurs
disgrace1248283disgrace
disguise1046833disguise
disgust937633disgust
dishes104622653dishes_
dishware1545433dishware
diskette1346753diskette
disks105417473dis_ks_
dislike122913453dislike
dismal92412243disma_l
dismaler1137903dismaler
dismals102010243dismals
dismasted1346833dismasted
dismasts1137513dismasts
dismay12229473disma_y
dismayed1535743dismayed
dismays13237433dismays
disme85716243dis__me
dismes95617673dismes_
dismiss1038153dismiss
dispart101115283dispart
dispels10310503dispels_
dispensed13158773dispensed
dispenser12128323dispenser
dispenses121210763dispenses
dispersed13119783dispersed
disperser12109083disperser
disperses121211773disperses
displace1348653displace
displeased1444483displeased
displeases1345683displeases
disposed12310943disposed
disposer11310413disposer
disposes11313823disposes
dispraise1248343dispraise
dispute1039083dispute
disrated10915573disrated
disrates91118153disrates
disrobe1038993disrobe
diss56434483dis__s_
dissaved1337313dissaved
dissaves1239413dissaves
disseat83816923dissea_t
disseated11711083disseated
disseats93211503disseats
dissed85220183dis__sed
disseised1147863disseised
disseisee1047753disseisee
disseises1039333disseises
disseize1847183disseize
disserve1287443disserve
disses75225963dis__ses
dissuade1065933dissuade
distaff1467683distaff
distain8313783distain
distal73615773dista_l
distance11311853distance
distant83519953distant
distasted1137963distasted
distastes1039633distastes
distaves12311403distaves
distome10313233distome
disused93211033dis_used
disuses84015413dis_uses
disvalue1244433disvalue
disyoke1546233disyoke
ditas65923673di_tas_
dites66339153dite_s_
divas95418583di_vas_
diverge12347643diverge
divers105024963divers_
dives95832403dive_s_
divest106820073dive_st
divulse1134913divulse
dizens164911393dizens_
dosage82810003dos_age
dosers75723633dosers_
doses65938503dose_s_
ease45042333___ease
fease84824873__fease
finesse10187643finesse
firebase1346493firebase
fissate103010033fissate
grease75416233_grease
ideas65919013_ideas_
ideate7313683_ideate
idlesse834193idlesse
incase83615283_incase
isbas71010403_isbas_
jiveass1792163jiveass
kinase104210653ki_nase
lease55230263__lease
license9148423license
ligase7259913li_gase
limeade1076123limeade
lineage878983lineage
lineate7815153lineate
lipase8239103li_pase
lisente71210703lisente
mileage10299313mileage
misate81222693mis_ate
miscast11312413miscast
misdate101413963misdate
miseat82925703misea_t
miseaten10310773miseaten
miseats92815783miseats
misers85025703misers_
mises74740563mise_s_
misgave13298283misgave
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
misname11119483misname
mispage12310523mispage
misparse1237733misparse
misraise10410523misraise
misrate91319143misrate
missense1037963missense
mistake131312623mistake
misuse83213643mis_use
niseis63512023niseis_
pease75231113__pease
pileate93815923pileate
pipeage1236203pipeage
please84315733_please
release7312763release
risers64624783risers_
rises55244043rise_s_
roseate7613453roseate
seas45755273__seas_
seise54727853__seise
sense55526823__sense
sises55233833sise_s_
tease55428713__tease
tineas64616483tineas_
tisane6311573tis_ane
tsetse664693_tsetse
unease63816643_unease
urease64516993_urease
visage1049083vis_age
visas84317653vis_as_
viscose1237863viscose
vises84427773vise_s_
vistas94513273vistas_
vitesse1044583vitesse
wiseacre1343003wiseacre
wiseasses1244043wiseasses
wises85633193wise_s_
wisest95016443wise_st

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272536.26621389.6
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.51527427.6
 
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.