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

139 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
ectasis924961(None) 
ectases92911671ectases
entasis73012571entasis
crasis85020472_crasis
ecdysis1343222ecdysis
ecesis84611202ec_esis
ecstasies1145042ecstasies
ectatic11310122ectatic
entases72816272entases
entasia73110062entasia
entasias8269142entasias
epitasis1047432epitasis
pectases122411192pectases
stasis63116872_stasis
acrasia9310033acrasia
acrasias1048893acrasias
acrasin9311223acrasin
acrasins1039973acrasins
astasia7310933astasia
astasias8410143astasias
basis75429863__basis
beclasps1444353beclasps
cadis84428503_c_adis
casas75327843_c_asas
cases75048383_c_ases
casks115720063_c_asks
cassis84818853_cassis
casts77237793_c_asts
casus76419253_c_asus
ceases84427073_ceases
centesis1058143centesis
cetanes9315133cetanes
chais107530313_cha_is
chases115128233_chases
chasms135513143_chasms
chassis123910663_chassis
clasps104512093_clasps
class75525483_clas_s
classis93712723_classis
clasts84817293_clasts
coasts85719143_coasts
coatis85122603_coatis
crases85532313_crases
crass76328043_cras_s
crisis83716343_crisis
cyesis1148573_cyesis
dalasis8810533dalasis
deceases11410153deceases
declass1038733declas_s
eases56041613e__ases
easies64126633e__asies
easts57530323e__asts
ecdyses1333413ecdyses
ecesic10369223ec_esic
echards1337963echards
eclair836813ecla_ir
eclairs935963eclairs
eclats8313033ecla_ts
eclipsis1243693eclipsis
ecotages1136973ecotages
ecstasy1252603ecstas_y
ecstatic1246153ecstatic
ecstatics1344373ecstatics
ectopia1147693ectopia
ectopias1248273ectopias
ectopic1338153ectopic
ectypes1434803ectypes
emesis84712623e_mesis
emphasis15117673emphasis
encases93116053encases
enchases13310273enchases
enclasps1245133enclasps
enosis63816423e_nosis
entail61114343enta_il
entails7912823entails
entastic1048553entastic
epistasis1144983epistasis
epitases1038933epitases
erases64425403e_rases
estates74520183estates
esthesis1148463esthesis
etamin81311853e_tamin
etamins91511833e_tamins
etapes85415293e_tapes
etas46432273e_ta__s
etatism9610293e_tatism
etatist7415033e_tatist
etuis54013133e_t_uis
eucharis1347443eucharis
euclases1039223euclases
eustasies946023eustasies
eutaxies1545793eutaxies
eyases94513683e_yases
eyass84410783e_yas_s
geotaxis1644183geotaxis
hectares1338853hectares
ictuses938303ictuses
ketosis11429733ketosis
lactases1038513lactases
mitosis939633mitosis
mutases92012043mutases
myasis114010473_myasis
myiasis1245493myiasis
necrosis1048883necrosis
nectaries1149813nectaries
nectars938463necta_rs
oasis56422553__oasis
octadic1245713octadic
octads987333octa_ds
octanes91111393octanes
octans81411143octa_ns
octants9128733octants
octaves12316963octaves
octavos12134483octavos
octrois938333octrois
ostosis71310123ostosis
outasks1138173outasks
peccavis1743133peccavis
pectase112410363pectas_e
pectates122213953pectates
peltasts1035703peltasts
petasos948603petasos
petasus946363petasus
petsais938433petsais
phasis114614923_phasis
protasis102411973protasis
ptosis83611823_ptosis
recasts93413533rec_asts
reclasps1235053reclasps
sectaries11312243sectaries
stases64225563_stases
tamis76728733__tamis
tapis75028863__tapis
tasks94917583__tasks
tass45640573__tas_s
tatamis939723tatamis
taxis126821973__taxis
teniasis846063teniasis
whatsis1335253whatsis

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.406440125.6
2DLD Change Limit1340271396.64020184.8
3Display Results1391390.0502780.0
 (SQL Overall)1786911397.09625181.9
 
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.