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

410 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
elapses95766(None) 
elapse857521elapse_
elapsed1056101elapsed
lapses85217691_lapses
relapses1038031relapses
apses76823912__apses
classes94717942classes
clauses93813322clauses
eases56041612e_a_ses
eclipses1244212eclipses
elapids1036502elapids
elates65032362ela_tes
ellipses1044342ellipses
elopes85918162elop_es
erases64425402era_ses
etapes85415292etap_es
eyases94513682eya_ses
eyasses10388022eyasses
glasses84414272glasses
lapises93513462_lapises
lapse74917682_lapse_
lapsed94712582_lapsed
lapser84113142_lapser
lapsers93911052_lapsers
lapsus8437272_lapsus
lases54944762_la_ses
lasses64827592_lasses
leases65428112lea_ses
relapse947702relapse_
relapsed1136522relapsed
relapser1035272relapser
relapsers1164122relapsers
abases85720773aba_ses
agapes95212413agap_es
alates64833963ala_tes
aldoses8311203aldoses
aliases7914493aliases
amasses93912853amasses
anlases72514903anla_ses
apes66047433__ap_es
apoapses1244713apoapses
apres75426403__apres
apse67725383__apse_
apsis75718293__apsis
arses55733873__arses
asepses946363asepses
asses55629283__asses
atlases72410643atla_ses
baases85218013_baases
balases93815433balases
bases75644353_ba_ses
basses85428303_basses
beladies11310423beladies
biases84618433bia_ses
biasses94911653biasses
blades95221253bla_des
blames105121863bla_mes
blares85021633bla_res
blase75524233bla_se_
blasts85116773bla_sts
blazes174817353bla_zes
blesses93812393blesses
blisses94911513blisses
blouses94014463blouses
blypes13357543blyp_es
bolases93315003bola_ses
braises93818873braises
brasses93818353brasses
capes95441923_cap_es
carses85233653_carses
cases75048383_ca_ses
causes88026473_causes
ceases84427073cea_ses
chaises124317493chaises
chaoses124715123chaoses
chapes135421873chap_es
chases115128233cha_ses
chasses124017503chasses
clades94920463cla_des
clapped143511173clapped
clapper134011863clapper
clappers143310833clappers
claps95626183clap__s
claques18279013claques
claries93422203claries
claroes93113733claroes
clashes124017283clashes
clasped123610443clasped
clasper113811863clasper
claspers124410913claspers
clasps104512093cla_sps
class75525483cla_s_s
classed104113653classed
classer93614613classer
classers104111833classers
classis93712723classis
clasts84817293cla_sts
clause84311503clause_
claves115020063cla_ves
cleanses10358143cleanses
clepes104214623clep_es
closes85425593cl_oses
collapses1344683collapses
copses104922473_copses
corpses113913803corpses
crapes104727693crap_es
crases85532313cra_ses
daises74318983_daises
debases103814133deba_ses
declasses1246443declasses
degases93413103dega_ses
degasses10278363degasses
delaines9312963delaines
delates83526283dela_tes
delouses9310013delouses
drapes95419653drap_es
eagles73819163e_agles
eagres74014573e_agres
ease45042333e_a_se_
eased65430403e_a_sed
easel54521113e_a_sel
easels65914553e_a_sels
easies64126633e_asies
easts57530323e_a_sts
eaves85231993e_a_ves
ecartes94212563ecartes
ecdyses1333413ecdyses
eclipse1144183eclipse_
eclipsed1343473eclipsed
eclipser1242793eclipser
eclipsers1342643eclipsers
eclipsis1243693eclipsis
ectases92911673ectases
effuses1335903effuses
egises7312493e_gises
elains64919853ela_ins
elands74914773ela_nds
elans55527753ela__ns
elapid939543elap_id
elapine9310673elapine
elapsing1146713elapsing
elastases946113elastases
elate55335883ela_te_
elated74725823ela_ted
elater64724203ela_ter
elaters74420193elaters
elatives1139783elatives
eldress835003eldress
elegies81312903elegies
elegises9128823elegises
elides74420693el_ides
elites66027123el_ites
ellipse944013ellipse_
ellipsis1043273ellipsis
elope75219343elop_e_
eloped95914143elop_ed
eloper85414153elop_er
elopers95112943elopers
else45923083el__se_
eluates72014683eluates
eludes75417683el_udes
elutes64020313el_utes
elves85118743el__ves
emeses86114963e_meses
empales112411433empales
enables92813123enables
enates64026423ena_tes
encases93116053encases
enlaces92313393enla_ces
enlarges946073enlarges
enolases8411013enola_ses
entases72816273entases
epees75219833e__pees
epopees1137233epopees
eposes84418783e_poses
erase54925493era_se_
erased74816753era_sed
eraser64216333era_ser
erasers74413943era_sers
eroses65327053e_roses
erses55826803e__rses
escapees12336333escapees
escapes113811673escap_es
eses45336103e___ses
espies83716803e_spies
esses56422973e__sses
etape74413703etap_e_
ethoses10311763ethoses
euclases1039223eucla_ses
evades1039023eva_des
evulses1035043evulses
examples1944313examples
exapted1736073exapted
excises1638933excises
excuses1638903excuses
expanses17156173expanses
exposes1639963exposes
eyass84410783eya_s_s
feases95422923fea_ses
flakes134118873fla_kes
flambes14419503flambes
flames114723693fla_mes
flanes94522423fla_nes
flanges113413273flanges
flapless1335343flapless
flapped15328253flapped
flapper14359203flapper
flappers15388383flappers
flaps105621383flap__s
flares94521703fla_res
flashes133916103flashes
flasks13488673fla_sks
flatuses1137173flatuses
flaxes165015353fla_xes
flenses1039473flenses
flosses103411973flosses
fraises104215693fraises
frappes14328383frappes
frasses104314513frasses
gapes86030823_gap_es
gases65633993_ga_ses
gasses75724783_gasses
gelates83219583gela_tes
glaces94218023gla_ces
glacises1138503glacises
glades84820343gla_des
glaires84010133glaires
glaives11347833glaives
glances104113143glances
glandes95413833glandes
glares75518863gla_res
glass65518133gla_s_s
glassed93710433glassed
glassies94012273glassies
glazes165315643gla_zes
glimpses1343953glimpses
glosses84014123glosses
grapes95123123grap_es
grasses84117343grasses
hanses95022633_hanses
hawses125113993_hawses
hearses104414533hearses
ileuses738673ileuses
japes146322823_jap_es
kelpies13289903kel_pies
kvases13467103kva_ses
kvasses14365503kvasses
laces76141763_la_ces
laches116528343_laches
lades65141273_la_des
ladies75124883_ladies
ladles74619543_ladles
lakes95737653_la_kes
lames75445543_la_mes
lampases1267293_lampases
lances84824103_lances
lanes54946793_la_nes
lapel73716683_lap_el
lapels83712043_lapels
lapides103012043_lapides
lapins84520683_lapins
lapis76223153_lap_is
lapped114320033_lapped
lapper104319953_lapper
lappers113717463_lappers
lappet103817723_lappet
lappets11329123_lappets
laps66848873_lap__s
larees65323113_larees
lares54852633_la_res
larges74824233_larges
lase46148513_la_se_
lased65132343_la_sed
laser54633323_la_ser
lasers64925703_la_sers
lashes94831003_lashes
lass47444543_la_s_s
lassies74420103_lassies
lassis65216703_lassis
lassoes74613853_lassoes
lassos64913813_lassos
lasts57731263_la_sts
lathes95127493_lathes
latkes104715873_latkes
lattes65324203_lattes
laves86039153_la_ves
laxes125430093_la_xes
lazes145129573_la_zes
lazies154418783_lazies
leaches123319343leaches
leagues837943leagues
leaped94317773leap_ed
leaper88118943leap_er
leapers93716663leapers
leaps75522933leap__s
lease55230263lea_se_
leased74722883lea_sed
leaser65322673lea_ser
leasers74717843lea_sers
leashes103514403leashes
leasts64616413lea_sts
leaves94222383lea_ves
lenses64620893_lenses
leses54930813_l_eses
lewises1039133lewises
liaises7311053liaises
lipases9209483_lipases
looses67328243_looses
lopes76437343_lop_es
loses56742013_l_oses
losses65925233_losses
louses66230283_louses
lupuses936273_lupuses
lyases95211873_lyases
lyses84518253_l_yses
malaises10312333malaises
manses84225513_manses
maples104819423_maples
marses84827113_marses
masses85028713_masses
megasses11307743megasses
melanges1138613melanges
melanoses1147293melanoses
molasses1037233molasses
myases113711553mya_ses
napes74828463_nap_es
nappes104515623_nappes
oases55330983_oa_ses
parses85534703_parses
pases75346503_pa_ses
passes86030473_passes
pauses84621473_pauses
peases85229473pea_ses
pelages10714613pela_ges
pelisses1048483pelisses
pelvises1337273pelvises
perhapses1644153perhapses
periapses1346053periapses
phases114618403pha_ses
places104323703pla_ces
plages94520153pla_ges
plagues103311063plagues
plaices11411143plaices
planes85028083pla_nes
plaques18317893plaques
plashes124417393plashes
plasms103711333pla_sms
plates85432243pla_tes
platies93722543platies
pleases94515483pleases
plisses94411773plisses
pluses83618073pl_uses
plusses93510693plusses
praises94121103praises
prases84429023pra_ses
prolapses13145573prolapses
quasses16209503quasses
raises64826543_raises
rapes75740723_rap_es
raphes115117453_raphes
rases55447213_ra_ses
realises82420183realises
relaces93420883rela_ces
relates73731433rela_tes
relaxes143215323rela_xes
releases8313343releases
repasses101810373repasses
reraises8415643reraises
retapes93917423retap_es
rhaphes1534703rhaphes
sasses64124393_sasses
scapes105122263scap_es
sepses84515883_sepses
serapes95218103serap_es
shapes115124943shap_es
slakes104021883sla_kes
slapped123511843slapped
slapper113512463slapper
slappers123710943slappers
slaps76025713slap__s
slashes103619103slashes
slates64934063sla_tes
slaves95023023sla_ves
slipes84921413slip_es
slopes84820453slop_es
slypes114410483slyp_es
stapes85028733stap_es
staples93617213staples
stases64225563sta_ses
synapses1344713synapses
taluses7311213taluses
tapes75838603_tap_es
tapises92914013_tapises
tasses64826763_tasses
tawses94913193_tawses
teases65426273tea_ses
teleses7313123tel_eses
texases1437573texa_ses
traipses1036873traipses
trapes85024463trap_es
trapeses1039153trapeses
trasses74819323trasses
ukases10358063uka_ses
upases84112903upa_ses
urases63723563ura_ses
valises103516263valises
valses94514613_valses
vases84626263_va_ses
woopses1237883woopses
wrasses103812593wrasses

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.1531167915.0
2DLD Change Limit1340274106.40620922.1
3Display Results4104100.1432867.1
 (SQL Overall)1786914106.70226662.3
 
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.