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

428 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
assays97790(None) 
assais6711961assais
assay8710281assay_
essays965651essays
allays94313742allays
always12409132always
arrays95311682arrays
assai5711542assa_i
assail6610152assail
assails769092assails
assayed1135592assayed
assayer1035572assayer
assayers1144842assayers
asses55629282ass_es
assess65710462assess
assets65617662assets
essay867622essay_
massas85116462massa_s
missays124010252missays
naysays1344122naysays
resays93714152resays
sashays1336332sashays
satays94411682satays
says75942102__says
shays116021432_shays
slays85723682_slays
spays105520512_spays
stays86022022_stays
sways115518462_sways
unsays9399542unsays
vassals1057952vassals
aahs716428563a__ahs
aals49941143a__als
aas310975393a__a_s
abas68642083a_ba_s
abases85720773abases
abaya104413173a_baya
abayas114011703a_bayas
abbas95918643abba_s
abbeys13538423abbeys
abys97221883a__bys
admass957143admass
afars85716513a_fars
affrays1644063affrays
agars66120643a_gars
agas55938843a_ga_s
aghas97014873agha_s
agmas85919873agma_s
airways1336243airways
aisles64721143aisles
alans55636173a_lans
alas46358123a_la_s
albas75925393alba_s
alfas87219043alfa_s
algas65624933alga_s
alias55834603alia_s
aliyas93911803aliyas
allay85620393allay_
alleys95113303alleys
alloys94014563alloys
almahs118611613almahs
almas76629773alma_s
altars64518153altars
alway116113923alway_
amahs107819063a_mahs
amas67746293a_ma_s
amass77119683a_mass
amias75831473amia_s
anas46649863a_na_s
anears63717183anears
angas65827983anga_s
anlas55626933anla_s
annals66415923annals
annas55824883anna_s
annoys967523annoys
anoas57226493anoa_s
ansa45927773ansa__
ansae55720973ansa_e
ansate64517863ansate
antas55432033anta_s
anyways1644423anyways
appals104812943appals
apses76823913aps_es
apsis75718293aps_is
aquas142412613aqua_s
araks94820883a_raks
areas55935773area_s
argals75517713argals
arhats9312973arhats
arias55438023aria_s
arras55626133arra_s
array86317143array_
arses55733873ars_es
arsis55722423ars_is
arsons63917213arsons
asana5315483a_sana
asanas6514113asanas
ascaris93613323ascaris
ascots85312513ascots
ascus75013583a_scus
asdics9439863asdics
asea46327183asea__
ashcans1235183ashcans
ashes86230613a_shes
ashlars10297063ashlars
ashrams1236653ashrams
ashtrays14534203ashtrays
ashy107717353a_shy_
asides75118873asides
askant10412713askant
askers105915403askers
askos95011773a_skos
asks85721213a_s_ks
aslant6317753aslant
aspens85013353aspens
aspers86220313aspers
aspics104211563aspics
aspis74618143a_spis
asps65622093a_s_ps
asrama839193asrama
asramas938303asramas
ass37844063a_s__s
assagai843903assagai
assagais943813assagais
assassin844073assassin
assault747413assault
assaults843863assaults
assaying1236003assaying
assegais943953assegais
assent65119953assent
assents74512223assents
assert64922583assert
asserts74311793asserts
asset55932263ass_et
assign736783assign
assigns836193assigns
assist6314603assist
assists738473assists
assize1538633assize
assizes1638453assizes
assoil688543assoil
assoils776663assoils
assort64916383assort
assorts73310153assorts
assuage835683assuage
assuages936273assuages
assume897563assume
assumes967163assumes
assure6610773assure
assures7611403assures
asswage1144673asswage
asswages1255053asswages
asters65631603asters
astrals75515243astrals
astray95615543astray_
aswarm11107913aswarm
ataps76414833a_taps
atlas55821583atla_s
atmans84413963atmans
atmas75721013atma_s
attars64515313attars
audads8167103audads
auras55932553aura_s
avgas96912133avga_s
avians93711563avians
away108024223a_way_
ayahs116813523a_yahs
ays67050293___ays
azans146516883a_zans
balsams11579013balsams
balsas86417523balsa_s
bashaws15347713bashaws
basses85428303bass_es
bassets96414823bassets
bassly114610073bassly_
bassos85313703bass_os
bassy1012917103bass_y_
bays97143913__bays
belays114313853belays
bioassays1451753bioassays
brays106723113_brays
byways1734673byways
caesars9410733caesars
casas75327843casa_s
casbahs1436463casbahs
cashaws15398573cashaws
cassaba1145663cassaba
cassabas1245733cassabas
cassata938143cassata
cassatas1036683cassatas
cassava1255003cassava
cassavas1344803cassavas
cassias93514343cassias
cassis84818853cass_is
casuals91410523casuals
causals91411183causals
causeys12387223causeys
cays95437673__cays
chays135319743_chays
clays105521333_clays
copays134911273copays
coseys115215813coseys
dassies84418663dassies
days87637133__days
decays124612913decays
delays104014053delays
derays105514253derays
dismays13237433dismays
dossals8379293dossals
drays95819773_drays
embays131408333embays
escars83913133escars
eskars10357593eskars
essayed1134013essayed
essayer1033943essayer
essayers1133563essayers
essayist1143623essayist
esses56422973ess_es
estrays10529403estrays
fays108535363__fays
flays116321053_flays
forays124813003forays
fossas94610703fossa_s
frays116920103_frays
gainsays1243503gainsays
gamays126310913gamays
gasbags1135473gasbags
gassers84714633gassers
gasses75724783gass_es
gassy95514023gass_y_
gays87338023__gays
gossans836783gossans
grays95621333_grays
hansas94616043hansa_s
hassels104311013hassels
hassles103411693hassles
hays106138073__hays
hearsays1444513hearsays
hoseys124614003hoseys
hussars10326983hussars
inlays9389873inlays
isbas71010403isba_s
isseis638563isseis
issues648803issues
jassids1586143jassids
jays146328343__jays
kasbahs1634363kasbahs
kashas133311903kasha_s
kays116032193__kays
lascars979013lascars
lasses64827593lass_es
lassies74420103lassies
lassis65216703lass_is
lassoes74613853lassoes
lassos64913813lass_os
lays76043253__lays
lyssas935443lyssa_s
margays1337493margays
masas75630413masa_s
massa75518923massa__
massage1039893massage
massages1159883massages
masses85028713mass_es
massifs1237743massifs
massy104518963mass_y_
matsahs1236563matsahs
maydays1634493maydays
mays96940033__mays
mesas76823203mesa_s
messans92710463messans
misassays1442533misassays
mislays12349243mislays
missals93914423missals
missay114112143missay_
morays114613883morays
moseys114711703moseys
nasals63312463nasals
nays75931593__nays
naysay1234973naysay_
noways12127733noways
ofays11488923_ofays
okays12609443_okays
onlays9398713onlays
ossa43714163ossa__
outsays102710403outsays
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
parlays123910453parlays
pascals11610013pascals
pashas115117063pasha_s
passade1039233passade
passades1139203passades
passado1037053passado
passados1146303passados
passage1039803passage
passages1139513passages
passant9813943passant
passels93913023passels
passers94717753passers
passes86030473pass_es
passkeys1742323passkeys
passus83610293pass_us
pastas85422873pasta_s
paydays1634433paydays
pays95940223__pays
plays106320773_plays
prays105022433_prays
pshaws14435703pshaws
psoas75012983psoa_s
quays174612043_quays
rascals959663rascals
rassles73513923rassles
rays77642353__rays
relays94316753relays
repays113813973repays
resaws93713513resaws
resay85320543resay_
sabals84618863sabals
sabs66643743__sabs
sacs65739073__sacs
sagas66025883saga_s
sags55948403__sags
salads75316963salads
salals65120083salals
sals46851673__sals
salsas65316133salsa_s
sans45153363__sans
sansars73313913sansars
saps65346373__saps
sarans64224433sarans
sarsars73512143sarsars
sashay1238363sashay_
sashes94728483sashes
sasins64923103sasins
sass45035623__sass
sassaby1244003sassaby
sasses64124393sasses
sassies74719263sassies
sassy85813813sassy_
satay84718463satay_
savoys12427893savoys
saws75839483__saws
say67264763__say_
sayst85322003__sayst
scabs94818643_scabs
scads85419963_scads
scags85520973_scags
scams94423973_scams
scans74625103_scans
scars75433533_scars
scats75930603_scats
seals54839693_seals
seams75731663_seams
sears54744913_sears
seas45755273_sea_s
seats54844343_seats
shads95124483_shads
shags95123863_shags
shahs115919513_shahs
shams105829413_shams
shaws116226263_shaws
shay107133343_shay_
sials54227243_sials
sisals63013573sisals
skags104316073_skags
skas85325713_ska_s
skats94621543_skats
slabs75322643_slabs
slags66525903_slags
slams74927903_slams
slaps76025713_slaps
slats55436903_slats
slaws85222713_slaws
slay76436383_slay_
snags64421313_snags
snaps74719563_snaps
snaws86116363_snaws
soaks95220293_soaks
soaps75120713_soaps
soars54732513_soars
soyas84520913_soyas
soys75233933__soys
spaes76029973_spaes
spams94922193_spams
spans74528733_spans
spars75431543_spars
spas67036723_spa_s
spats75031383_spats
spay96631663_spay_
splays114910873splays
sprays115913643sprays
stabs76221383_stabs
stags66226743_stags
stars55836573_stars
stats55933363_stats
stay78333723_stay_
strays96417933strays
swabs105817273_swabs
swags94921253_swags
swans84625013_swans
swaps104819203_swaps
swats85726863_swats
sway107128233_sway_
tarsals72512603tarsals
tassels74510853tassels
tasses64826763tass_es
tassets75012773tassets
tassies74918933tassies
todays10458103todays
tokays13397773tokays
trays85623433_trays
tsars56717113_tsars
tussahs10335113tussahs
tussars7359253tussars
unlays93810493unlays
unsay83212843unsay_
usuals637783usuals
vassal979243vassa_l
visas84317653visa_s
warsaws1335763warsaws
washdays1842863washdays
wassail1056133wassail
wassails1145953wassails
waylays1634673waylays
ways107737953__ways
yasmaks1633653yasmaks
yays105728913__yays

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127164285.32621163.3
3Display Results4284280.1403057.1
 (SQL Overall)1786914285.59231954.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.