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

229 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
discase10291286(None) 
discased122510851discased
discases112014501discases
disease83213841disease
diabase1037112diabase
diastase946602diastase
dicast9315572di_cast
diocese1036852diocese
diphase1387272diphase
discant103017262discant
discard11310212discard
disclose1148742disclose
discos94915212discos_
discs85316262disc_s_
discus94512112discus_
discuses113112862discuses
discuss10357952discuss
diseased103011712diseased
diseases92415812diseases
diseuse83110722diseuse
dismast10311232dismast
dispose10312762dispose
disrate81418522disrate
dissave1139412dissave
distaste939942distaste
disuse74012842dis_use
incase83615282_incase
miscast11312422miscast
misease92713042misease
viscose1237862viscose
abscise1145953abscise
airscape1245363airscape
bistate9313823bistate
boscage1276533boscage
carcase11312743carcase
cascade12118603cascade
case65848083___case
casease939323casease
cicale10314503ci_cale
ciscoes113610733ciscoes
ciscos104711133ciscos_
daycare1355093daycare
debase94014473d_ebase
decade104216163d_ecade
decane93818873d_ecane
decare93919153d_ecare
decease1049523decease
descant104315593descant
despise1038683despise
diabases1137223diabases
dialyse1135463dialyse
diapause1143893diapause
diastases1047073diastases
dicasts1078703di_casts
dice75841893di_c__e
dices86434243di_ces_
dickie133913113di_ckie
dicks125824693di_cks_
dictate10311663dictate
diffuse1444373diffuse
dilate73220693di_late
dioceses1137113dioceses
dioptase1145513dioptase
dioxane1565423dioxane
dipsas9359893dipsas_
disable10516433disable
disabuse1145553disabuse
disarm9310473dis_arm
disaster949943dis_aster
disband1138243disband
disbar938513disba_r
disbars10310323disbars
disburse1186443disburse
disc76123233disc___
discalced1545653discalced
discanted1339333discanted
discants112912023discants
discarded1437083discarded
discarder1346753discarder
discards1238913discards
discasing1339433discasing
disced104914653disc_ed
discept12310623discept
discern1038493discern
discharge1664843discharge
disci85815023disc__i
discing113914593discing
disciple1346673disciple
disclaim1345643disclaim
disclike15208653disclike
disclosed1347363disclosed
discloser1256803discloser
discloses1249473discloses
disco85616073disc__o
discoed11312483discoed
discoid11311243discoid
discord1139993discord
discourse1246863discourse
discover1439563discover
discreet11413183discreet
discrete11410283discrete
discussed13256763discussed
discusser12246183discusser
discusses12268253discusses
disdain938513disdain
diseuses93112763diseuses
disgrace1248283disgrace
disguise1046833disguise
disgust937633disgust
dishes104622653dishes_
dishware1545433dishware
disks105417473dis_ks_
dislike122913453dislike
dislocate1289133dislocate
dismal92412243disma_l
dismaler1137903dismaler
dismals102010243dismals
dismasted1346833dismasted
dismasts1137513dismasts
dismay12229473disma_y
dismayed1535743dismayed
dismays13237433dismays
disme85716243dis__me
dismes95617673dismes_
dismiss1038153dismiss
dispart101115283dispart
dispense11129783dispense
disperse111011353disperse
displace1348653displace
displease1245523displease
disposed12310943disposed
disposer11310413disposer
disposes11313823disposes
dispraise1248343dispraise
dispute1039083dispute
disrated10915573disrated
disrates91118153disrates
disrobe1038993disrobe
diss56434483dis__s_
dissaved1337313dissaved
dissaves1239413dissaves
dissed85220183dis__sed
disseise939853disseise
disses75225963dis__ses
dissuade1065933dissuade
distaff1467683distaff
distain8313783distain
distal73615773dista_l
distance11311853distance
distant83519953distant
distasted1137963distasted
distastes1039633distastes
distaves12311403distaves
distome10313233distome
disused93211033dis_used
disuses84015413dis_uses
disvalue1244433disvalue
disyoke1546233disyoke
ditas65923673di_tas_
ditches133215713ditches
divas95418583di_vas_
diverse11429993diverse
divulse1134913divulse
dosage82810003dos_age
encase83714363_encase
escape103811663_escape
fincas113512073fincas_
fiscal1139333fisca_l
fiscals1238003fiscals
fiscs105311883fisc_s_
fissate103010033fissate
idocrase1183603idocrase
incage93513623_incage
incased103612393_incased
incases93615973_incases
incise83515333_incise
incuse83513573_incuse
inscape1138023inscape
isbas71010403_isbas_
kinase104210653ki_nase
ligase7259913li_gase
lipase8239103li_pase
micas96823053mi_cas_
misate81222693mis_ate
miscall1139653miscall
miscasts1238353miscasts
mischose1547263mischose
miscite11314383miscite
misclass1246843misclass
miscode12310413miscode
miscue10412223misc_ue
miscues11312393miscues
misdate101413963misdate
miseases102614343miseases
misgave13298283misgave
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
misname11119483misname
mispage12310523mispage
misparse1237733misparse
misraise10410523misraise
misrate91319143misrate
mistake131312623mistake
misuse83213643mis_use
muscae10410673musca_e
nutcase975763nutcase
picas94626523pi_cas_
piscary1437423piscary
piscine11610973piscine
piscos105112593piscos_
rescale93215473rescale
scale74629143__scale
scape96921843__scape
scare75334463__scare
slipcase1263923slipcase
suitcase1043893suitcase
tisane6311573tis_ane
uncase83817433_uncase
upscale11136323upscale
vincas113912453vincas_
visage1049083vis_age
visas84317653vis_as_
viscoses1338343viscoses
viscus11428503viscus_
vistas94513273vistas_
wiccas1336543wiccas_
wiseass1035823wiseass
zincate1838533zincate

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.390458182.1
2DLD Change Limit1340272295.72023431.3
3Display Results2292290.0932462.4
 (SQL Overall)1786912296.20328807.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.