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

367 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
demasts108922(None) 
demast9517061demast_
beasts84519722be_asts
bemists113410702bemists
damasks1435072damasks
debases103814132debases
decants103514442decants
defats105114552defa_ts
degases93413102degases
degusts936062degusts
deists74916432de_ists
delists84414172delists
demands114311412demands
demarks14339232demarks
demasted1238762demasted
dements103016622dements
demises103719562demises
demits94918072dem_its
demoses103815822demoses
departs104310682departs
derats74625062dera_ts
desalts839572desalts
desists83611722desists
detests83711742detests
devests114410472devests
dicasts1078702dicasts
dismasts1137512dismasts
durmasts1144092durmasts
dynasts1155102dynasts
easts57530322_e_asts
feasts95116092fe_asts
leasts64616412le_asts
masts77035762__masts
recasts93413532recasts
repasts93611932repasts
yeasts96413052ye_asts
adamants1186343adamants
admass957143admas_s
amass77119683_amas_s
basts75936933__basts
beast76338643be_ast_
beats76042243be_a_ts
beauts86015283be_auts
behests1235953behests
bemas96424283bema__s
bemata10411693bema_ta
bemist105216963bemist_
bemuses1139293bemuses
bests75932613be__sts
bezants1877343bezants
blasts85116773_blasts
boasts85017923_boasts
bombasts1444953bombasts
breasts939703breasts
camases114216343camases
camass104114183camas_s
casts77237793__casts
ceases84427073ce_ases
cements112714223cements
cerastes101111093cerastes
chemists152710323chemists
clasts84817293_clasts
coasts85719143_coasts
dadaists1045583dadaists
dalasis8810533dalasis
damages11511273damages
damans94715983dama_ns
damars93814993dama_rs
damask1335843damas_k
darts67635733d__arts
dauts67822243d__auts
dawts97216123d__awts
deads75726913de_a_ds
deairs74013783de_airs
deals65435343de_a_ls
dealt65234283de_alt_
deans66131393de_a_ns
dears65736883de_a_rs
dearth104212513de_arth
dearths11498843de_arths
deash95617243de_as_h
deashes113313903de_ashes
deasil71110983de_asil
death94822523de_a_th
deaths105914443de_aths
deaves105319533de_aves
debags104211063deba_gs
debarks14388493debarks
debars94218043deba_rs
debase94014473debas_e
debased113310583debased
debaser103510413debaser
debasers11377903debasers
debate94419193deba_te
debates103718533debates
debits94214503de_bits
debts86418373de__bts
debuts93911753de_buts
decades113615513decades
decafs124010883deca_fs
decals93717713deca_ls
decamps1435643decamps
decanes103118913decanes
decant93524223decant_
decares102818533decares
decays124612913deca_ys
deceases11410153deceases
deceits102810883deceits
declass1038733declas_s
decocts1237833decocts
dedans85915073deda_ns
deducts1166593deducts
deets65330243de__ets
defaces133213403defaces
defames132812253defames
defangs1235363defangs
defat95426693defa_t_
defaults1243333defaults
defeats113511233defeats
defects134511523defects
defrosts1244833defrosts
defuses114814593defuses
degames113312623degames
degamis11268443degamis
degas75119163dega__s
degasses10278363degasses
degauss933923degauss
degust8310253degust_
dehorts11379773dehorts
deisms94411043de_isms
deist64633593de_ist_
dejects17389223dejects
dekares122710873dekares
delate73827753dela_te
delates83526283delates
delays104014053dela_ys
delfts10439673de_lfts
delicts104012253delicts
delist74625053delist_
delts65731793de__lts
demagog1243853demagog
demagogs1343883demagogs
demand104314253dema_nd
demark134211023dema_rk
demasting1338453demasting
demeans1039723demeans
dement93825153dement_
demerits11310763demerits
demes86032693dem__es
demesne1035573demesne
demesnes1137083demesnes
demies94825803dem_ies
demise94618323demis_e
demised113613683demised
demister11310223demister
demisters1249203demisters
demit84832303dem_it_
demobs11429483dem_obs
demonists1248703demonists
demons94917723dem_ons
demos86022993dem__os
demote94817803dem_ote
demotes104717673demotes
demotists1247323demotists
demounts1135473demounts
dempster1355773dempster
dempsters1435273dempsters
demurs939773dem_urs
denars74621433dena_rs
dentists939263dentists
dents65031803de__nts
depaints1136643depaints
depart94720563depart_
depicts12358463depicts
deports105012883deports
deposes103117213deposes
deposits1138843deposits
depots94716343de_pots
derails84216393derails
derat65044083dera_t_
derate74531233dera_te
derates84028893derates
derays105514253dera_ys
dermas94116813derma__s
dermises112512023dermises
desalt7518313desalt_
desands94810163desands
descants112910143descants
deserts82513053deserts
desist74818813desist_
desks105913073de__sks
desmans1039003desma_ns
despots10319683despots
details84214043details
detains83716093detains
detects104011093detects
detents83615153detents
detest74122843detest_
detracts11138833detracts
devas96218883deva__s
devest104418703devest_
deviants1236733deviants
devises114116763devises
dewans105215143dewa_ns
dewars105117073dewa_rs
dewaxes18297843dewaxes
dicast9315573dicast_
didacts1186063didacts
digests93610613digests
dimouts1037893dimouts
dimwits1344513dimwits
dismast10311233dismast_
divests114510933divests
doats65224883d_oa_ts
domains10510873domains
dopants1038433dopants
drafts105012533d_rafts
drats66628373d_ra_ts
ducats95011763duca_ts
duelists966003duelists
dumas85420433duma__s
durmast1037623durmast_
dusts65923563d__usts
dynast1088223dynast_
dynasty1463203dynasty
eases56041613_e_ases
east46659103_e_ast_
eats47054873_e_a_ts
edemas9310503edema__s
edemata1046003edema_ta
egests74411253_egests
emails84412343_emails
emeses86114963_emeses
emesis84712623_emesis
emits75421473_em_its
emmets10349153_emmets
enacts84012973_enacts
epacts105010393_epacts
erases64425403_erases
exacts15359613_exacts
exalts13328313_exalts
exists134710913_exists
eyases94513683_eyases
eyass84410783_eyas_s
fasts86429683__fasts
feases95422923fe_ases
feast85932723fe_ast_
feats86432753fe_a_ts
feists94915313fe_ists
females12310663females
fests85828043fe__sts
foremasts1445793foremasts
gasts66628633__gasts
geests75912163ge_ests
gelants82611443gelants
gemots93712153gem_ots
gests66028813ge__sts
gymnasts1442433gymnasts
hearts96218943he_arts
heats85838403he_a_ts
heists96814633he_ists
heliasts1136103heliasts
hests85829933he__sts
jests125922453je__sts
lambasts12145623lambasts
lasts57731263__lasts
leases65428113le_ases
least56134883le_ast_
legists899593legists
lemans85316393lema_ns
levants1037723levants
maists85817573__maists
malts76331753__malts
marts77442233__marts
masas75630413__masas
masks115320533__masks
mass66044943__mas_s
mast65959963__mast_
mats65460293__ma_ts
matts76829183__matts
mauts75927193__mauts
meats75034053me_a_ts
megass9219443megas_s
mists76633903__mists
mosts76028543__mosts
musts75527443__musts
neats55931903ne_a_ts
nemas75321573nema__s
nemeses948663nemeses
nemesis937373nemesis
nests55728003ne__sts
oasts56529183__oasts
oblasts947303oblasts
pasts75936503__pasts
peases85229473pe_ases
peats76140193pe_a_ts
pedants10310113pedants
pederasts1255203pederasts
peltasts1035703peltasts
pests75933273pe__sts
petasos948603petasos
petasus946363petasus
precasts1239453precasts
reacts83616603re_acts
rebaits9312573rebaits
recants93217093recants
recast83422773recast_
redacts10510943redacts
reests64618893re_ests
relists73817053relists
remails94714563remails
remains94117913remains
remakes134116173remakes
remands104914883remands
remans84823003rema_ns
remaps105012873rema_ps
remarks13329983remarks
remaster10311473remaster
remasters11310583remasters
remate84428683rema_te
remates93827113remates
remeets93712413remeets
remelts93511493remelts
remints95117293remints
remises93423483remises
remiss84216353remis_s
remits85622943rem_its
remnants1036843remnants
renests74014213renests
repass84114703repas_s
repast83520633repast_
resists74414923resists
rests54935873re__sts
retaste72313133retaste
retastes82212903retastes
retests73813853retests
revests104413733revests
roasts64915413_roasts
seats54844343se_a_ts
secants93413893secants
semises93916553semises
sexists14267673sexists
smalts85214893_smalts
smarts86218003_smarts
teases65426273te_ases
teats55636813te_a_ts
tempests1234443tempests
tempts10439453tem_pts
tenants7311013tenants
tests56530193te__sts
texases1437573texases
toasts65914993_toasts
topmasts1244973topmasts
unmasks1344553unmasks
upcasts11185643upcasts
utmosts934593utmosts
vasts86423773__vasts
verists103613673verists
versts93914733ve_rsts
vests85325983ve__sts
wasts87433673__wasts
webcasts1543313webcasts
wests85727003we__sts
yeast85327943ye_ast_
yeasty12438693ye_asty
zests145419743ze__sts
zymases21938333zymases

Search took 8 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 Limit1340273676.64320175.7
3Display Results3673670.1232983.7
 (SQL Overall)1786913677.15624970.8
 
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.