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

260 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
dicasts107870(None) 
dicast9315571dicast_
casts77237792__casts
decants103514442decants
demasts1089222demasts
dicastic1347342dicastic
dicots94915792dic_ots
didacts1186062didacts
digests93610612digests
discants112912022discants
discases112014502discases
dismasts1137512dismasts
divests114510932divests
ducats95011762duca_ts
dynasts1155102dynasts
miscasts1238352miscasts
recasts93413532recasts
upcasts11185642upcasts
accosts11107993accosts
basts75936933__basts
beasts84519723_beasts
biases84618433bi_ases
bicarbs1336013bicarbs
blasts85116773_blasts
boasts85017923_boasts
breasts939703breasts
cants77036943__cants
carts78946293__carts
casas75327843__casas
cases75048383__cases
casks115720063__casks
cast67159903__cast_
caste75932363__caste
castes85631863__castes
casus76419253__casus
cats66356343__ca_ts
cicadas1235993cicadas
cicalas1139303cicalas
cineasts1045543cineasts
cists76624533__cists
clasts84817293_clasts
coasts85719143_coasts
costs77231143__costs
cycases1437533cycases
cysts105912773__cysts
dacoits1079073dacoits
dadaists1045583dadaists
dalasis8810533dalasis
damasks1435073damasks
darts67635733d__arts
dauts67822243d__auts
dawts97216123d__awts
debases103814133debases
decades113615513decades
decafs124010883deca_fs
decals93717713deca_ls
decamps1435643decamps
decanes103118913decanes
decant93524223decant_
decares102818533decares
decays124612913deca_ys
deceases11410153deceases
deceits102810883deceits
declass1038733declas_s
decocts1237833decocts
defats105114553defa_ts
degases93413103degases
degusts936063degusts
deists74916433d_eists
delists84414173delists
demast9517063demast_
departs104310683departs
derats74625063dera_ts
desalts839573desalts
descants112910143descants
desists83611723desists
detests83711743detests
devests114410473devests
diabases1137223diabases
diacids1137863diacids
dialists9411413dialists
dials64925343di_a_ls
diarists9410363diarists
diastase946603di_astase
diastem10318043di_astem
diastems11226523di_astems
diaster82813313di_aster
diasters92913183di_asters
dibasic1246033dibasic
dicamba1453413dicamba
dicambas1553793dicambas
dicers94720743dic_ers
dices86434243dic__es
dichasia1445283dichasia
diciest103316523diciest_
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
dickies143416343dickies
dicks125824693dic__ks
dicot85429093dic_ot_
dicta84915633dic__ta
dictate10311663dictate
dictates11311383dictates
dictums1235553dictums
dicty115116293dic__ty
didact10711203didact_
didst74619613di_dst_
dieses75218693di_eses
diesis74013493di_esis
diets66026643di__ets
digamists1345003digamists
digest84019623digest_
dights114016963di_ghts
digits84114533di_gits
diglots9299503diglots
diktats1235623diktats
dilate73220693dila_te
dilates83220663dilates
dimouts1037893dimouts
dimwits1344513dimwits
dinars75417563dina_rs
dints67431313di__nts
dioceses1137113dioceses
dipnets10109033dipnets
dipsas9359893di_psas
dipsos95310053di_psos
diquats1745983diquats
dirams94413703dira_ms
directs102710263directs
direst75024243direst_
dirts66824463di__rts
disarms1039043disarms
disaster949943disaster
disasters1039153disasters
discant103017263discant_
discards1238913discards
discase102912863discas_e
discased122510853discased
discepts1336743discepts
discs85316263di__scs
discuses113112863discuses
discuss10357953discus_s
diseases92415813diseases
disgusts1045663disgusts
disks105417473di__sks
dismast10311233dismast_
disparts11109953disparts
diss56434483di__s_s
disses75225963di_sses
distaste939943distaste
distastes1039633distastes
disuses84015413disuses
ditas65923673dita__s
dits56450523di___ts
divans104612393diva_ns
divas95418583diva__s
diverts114412033diverts
divest106820073divest_
divots104712203di_vots
diwans105110373diwa_ns
dixits144210313di_xits
doats65224883d_oa_ts
docents102810803docents
dockets144412243dockets
dogcarts1243883dogcarts
dopants1038433dopants
downcasts1542913downcasts
drafts105012533d_rafts
drats66628373d_ra_ts
ducat86225903duca_t_
ducts85319893duc__ts
durmasts1144093durmasts
dusts65923563d__usts
dynast1088223dynast_
dynasty1463203dynasty
easts57530323__easts
edicts94911703edic__ts
encases93116053encases
encysts1244313encysts
endocasts1244763endocasts
fasts86429683__fasts
feasts95116093_feasts
fiats85324483fi_a_ts
ficuses12159203ficuses
firsts95110923fi_rsts
fists85527543fi__sts
gasts66628633__gasts
giants74713503gi_ants
gists66026193gi__sts
hists86328373hi__sts
ikats95311153_ika_ts
incants92012803incants
incases93615973incases
incests92711383incests
indicants1247203indicants
jicamas1845053jicamas
kinases113511123kinases
kists95822113ki__sts
lasts57731263__lasts
leasts64616413_leasts
lichts113712383lic_hts
ligases82310713ligases
lipases9209483lipases
lists56628693li__sts
locusts9277933locusts
masts77035763__masts
medicants1466783medicants
miasms1097383mi_asms
micas96823053mica__s
midsts95510053mi_dsts
misacts1139353misacts
miscast11312423miscast_
mists76633903mi__sts
nicads938333nica_ds
nicest82315663nicest_
oasts56529183__oasts
oblasts947303oblasts
ocicats11137413ocica_ts
odists749853odi__sts
offcasts1643013offcasts
oocysts1243923oocysts
outcasts10108683outcasts
oxcarts1634313oxcarts
pasts75936503__pasts
picante11310523picante
picaras11311283picaras
picaros11310893picaros
picas94626523pica__s
pickets154314183pickets
picots104616443pic_ots
precasts1239453precasts
racists92613323racists
recants93217093recants
recast83422773recast_
repasts93611933repasts
rickets134915093rickets
riposts9279403riposts
roasts64915413_roasts
scants85219723_scants
scarts85321493_scarts
scats75930603_sca_ts
scatts85914663_scatts
secants93413893secants
ticals83214713tica_ls
tickets134113683tickets
tipcarts1244573tipcarts
tipcats1137103tipca_ts
toasts65914993_toasts
uncases93516553uncases
uncast84215713uncast_
upcast102710093upcast_
vasts86423773__vasts
vibists1256483vibists
vicars11712263vica_rs
wasts87433673__wasts
webcasts1543313webcasts
wickets164010943wickets
wists86728523wi__sts
yeasts96413053_yeasts

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.403443402.0
2DLD Change Limit1340272606.31321230.3
3Display Results2602600.0932795.7
 (SQL Overall)1786912606.80926243.4
 
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.