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

516 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
fossas9461070(None) 
fossa85812631fossa_
fossae95510371fossae
fosses96022081fosses
bosses85925402bosses
dossal75510302dossal
dossals8379292dossals
dosses76126272dosses
fesses94820252fesses
flosses103411972flosses
foists95413982foists
foss76431642fo_s_s
fossate10388602fossate
fosse86119462foss_e
fossil9379352fossil
fossils10379012fossils
foveas1238622foveas
fusses94920552fusses
glossas8438192glossas
gossan747232gossan
gossans836782gossans
hostas94515822hostas
josses135117682josses
losses65925232losses
lyssas935442lyssas
massas85116462massas
mosses85527682mosses
ossa43714162_ossa_
posses85128802posses
tosses65225392tosses
aftosas10147153aftosas
aortas65417783aortas
assai5711543_assai
assais6711963_assais
assay8710283_assay
assays977903_assays
asses55629283_asses
balsas86417523balsas
basses85428303basses
bassos85313703bassos
boas66150833bo__as
boasts85017923boasts
boheas114013213boheas
bolas74733763bo_las
bonsai838463bonsai
boosts86115013boosts
boras75938303bo_ras
boreas85421733boreas
boshes114721883boshes
bosks115218853bo_sks
bosoms104913053bosoms
bosons85016653bosons
boss65938343bo_s_s
bossed94816533bossed
bossies94116833bossies
bossism1136063bossism
bossy105515973boss_y
bosuns8439383bosuns
botas75328783bo_tas
bouses84931783bouses
bowses115718863bowses
boylas113011723boylas
bursas85318273bursas
busses85023383busses
byssal1134993byssal
byssus1133763byssus
casas75327843_casas
cassias93514343cassias
cassis84818853cassis
cesses84221363cesses
cestas85018543cestas
coalas87418963coalas
coasts85719143coasts
cobias104014993cobias
cobras104014193cobras
cocas95926573co_cas
cocoas104915743cocoas
codas84724243co_das
colas75436773co_las
colzas174010513colzas
comas95833003co_mas
commas124814573commas
compas125817063compas
congas94417033congas
copras103517153copras
copses104922473copses
corsac10410173corsac
corsacs1139013corsacs
corses84433463corses
cosecs105015213cosecs
coses76949493co_ses
cosets85824403cosets
coseys115215813coseys
coshes115022783coshes
cosies84932153cosies
cosmos10311753cosmos
coss66143493co_s_s
cossack1545823cossack
cossacks1645223cossacks
cosset84125863cosset
cossets95014283cossets
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
costars94218013costars
costs77231143co_sts
cottas84615573cottas
crosses94220793crosses
cusses84522773cusses
cussos84210003cussos
dipsas9359893dipsas
disses75225963disses
doblas93812293doblas
dobras94811913dobras
dogmas105011243dogmas
dolmas95213043dolmas
donas65926473do_nas
dongas84914613dongas
donnas75511323donnas
dopas85019063do_pas
dorsa64617283dorsa_
dorsad8408973dorsad
dorsal74613943dorsal
dorsals84110843dorsals
dosers75723633dosers
doses65938503do_ses
doss56235043do_s_s
dossed84516633dossed
dossel74813643dossel
dossels85511603dossels
dosser74417973dosser
dossers84516233dossers
dossil75110903dossil
dossils8669773dossils
doulas75114993doulas
doumas95314813doumas
douras75016723douras
douses74928933douses
dowses105718303dowses
drosses84513823drosses
eosins64419163eosins
essay867623_essay
essays965653_essays
esses56422973_esses
facias113415803facias
faenas94412763faenas
fangas105017193fangas
fas68262933f___as
fasces114914543fasces
fascias1258413fascias
fashes124524023fashes
fasts86429683f_asts
fatsos9389423fatsos
fatwas1249053fatwas
faunas94013633faunas
favas115618593f_avas
feases95422923feases
feasts95116093feasts
feists94915313feists
fellas95116963fellas
ferias95020393ferias
fess76529163f_es_s
fesse86116333fess_e
fessed104515063fessed
festal94213563festal
fests85828043f_ests
fetas85624403f_etas
fiestas1038433fiestas
fincas113512073fincas
firsts95110923firsts
fiscal1139333fiscal
fiscals1238003fiscals
fiscs105311883f_iscs
fishes125221343fishes
fissate103010033fissate
fists85527543f_ists
flasks13488673flasks
fleas86423663f_leas
floras94715693floras
floss85118263flos_s
flossed11388533flossed
flosser10339693flosser
flossers11307863flossers
flossie10337443flossie
flossies112810123flossies
flossy12517703floss_y
flotas94013003flotas
flotsam1244623flotsam
flotsams1343383flotsams
foal76630923fo__al
foals85721693fo_als
foam97127173fo__am
foams105017953fo_ams
fobs96034273fo__bs
focal104917673fo_cal
focus105815883fo_cus
focuses12159653focuses
focusses13155223focusses
foehns12204973foehns
foeman11311233foeman
foes76543443fo__es
foetal9311883foetal
foetus958523foetus
fogeys13509263fogeys
fogies104118063fogies
fogs87035003fo__gs
fohns117310783fo_hns
foils85025813fo_ils
foins85523383fo_ins
foison948933foison
foisons1047613foisons
foist85730973fois_t
folds95221693fo_lds
foleys123810463foleys
folia83618933folia_
foliar93210973foliar
folios93915463folios
folks126017123fo_lks
folles93820473folles
follis93113903follis
fonds95824823fo_nds
fondus105210943fondus
fons76943893fo__ns
fontal9313143fontal
fonts86124753fo_nts
foods95924163fo_ods
fools86824203fo_ols
foots85528283fo_ots
fops96532683fo__ps
fora75937393fo_ra_
foram105124933fo_ram
forams115115913forams
foray115023973fo_ray
forays124813003forays
forbad122710503forbad
forbs105720803fo_rbs
forces114422133forces
fords95328183fo_rds
fores85847103fo_res
foresaw1377133foresaw
forests104114953forests
forgat104018583forgat
forges105024263forges
forks125324683fo_rks
formal113215203formal
formals123312893formals
format113021353format
formats123113573formats
formes114623713formes
forms105327053fo_rms
forsake1436533forsake
forsakes1536893forsakes
fortes95327183fortes
fortis95418613fortis
forts86034453fo_rts
forums114611843forums
fossick16134733fossick
fossicks17134163fossicks
foster94322223foster
fosters104220103fosters
fouls87221433fo_uls
founds104814193founds
founts94313383founts
fours85521493fo_urs
fovea11310483fovea_
foveae1237563foveae
foveal1237703foveal
fowls115518893fo_wls
foxes156321093fo_xes
foyers125413133foyers
foys105628293fo__ys
fracas11311993fracas
frass85321123fras_s
frasses104314513frasses
frises94124273frises
frisks13479263frisks
frosts94214623frosts
frowsts13426103frowsts
fusees95416403fusees
fusels94412453fusels
fuses85628423f_uses
fusils93912343fusils
fuss76027933f_us_s
fussed104613803fussed
fusser94813773fusser
fussers104210813fussers
fussy115613953fuss_y
gasses75724783gasses
glossa7529163glossa_
glossae8477283glossae
glossal8447053glossal
glosses84014123glosses
goas55239943go__as
gooses75723053gooses
gorses74723293gorses
gossip946433gossip
gossips1035903gossips
grosses84517683grosses
hansas94616043hansas
hisses94719353hisses
hoises94823673hoises
hoists95516023hoists
hollas94616903hollas
hondas10313353hondas
hookas135312493hookas
horas86333103ho_ras
horses94729343horses
horsts95817513horsts
hosels94218603hosels
hosers95223963hosers
hoses85443173ho_ses
hoseys124614003hoseys
hosta85917833hosta_
hosts85526703ho_sts
houses96032273houses
hoyas115016163ho_yas
hussar9317283hussar
hussars10326983hussars
iotas54821113io_tas
isbas71010403_isbas
jesses135215953jesses
joists134711033joists
joshes165114853joshes
joss115925593jo_s_s
jotas125717443jo_tas
jousts135011273jousts
kashas133311903kashas
kisses104217333kisses
koalas104011663koalas
koas85635093ko__as
kolas94822233ko_las
koppas14407603koppas
koras95927113ko_ras
kormas124511233kormas
koss85224813ko_s_s
koussos11373903koussos
kussos10336423kussos
lasses64827593lasses
lassis65216703lassis
lassos64913813lassos
loess55714703loes_s
loessal744393loessal
loesses7310033loesses
loofas9429833loofas
looses67328243looses
losels64714583losels
losers65123583losers
loses56742013lo_ses
loss45337963lo_s_s
lossy85214643loss_y
lotas55926303lo_tas
loumas84812333loumas
louses66230283louses
lyssa835713lyssa_
masas75630413_masas
massa75518923massa_
masses85028713masses
mensas85115853mensas
mesas76823203_mesas
messan83912063messan
messans92710463messans
messes84924343messes
missal84314903missal
missals93914423missals
missay114112143missay
missays124010253missays
misses85130873misses
missis84417503missis
missus85312293missus
moas65545343mo__as
mochas13310663mochas
molas75132093mo_las
mommas94110653mommas
monas74732153mo_nas
moolas83615593moolas
moras76438773mo_ras
morass84614493morass
moseys114711703moseys
moshav1446053moshav
moshes115222873moshes
mosks116117003mo_sks
moss67641033mo_s_s
mossed94818893mossed
mosser84618273mosser
mossers94116193mossers
mosso74715183moss_o
mossy105217063moss_y
mosts76028543mo_sts
mouses85531423mouses
mousses94012703mousses
moxas145014393mo_xas
musses84624783musses
nesses64718323nesses
noesis6311443noesis
noises65021853noises
nomas74726413no_mas
nonas55126653no_nas
nooses65623643nooses
norias65518203norias
noses55435643no_ses
noshes96618233noshes
nouses64627163nouses
novas85215363no_vas
oases55330983_oases
oasis56422553_oasis
oasts56529183_oasts
obas65730933_o_bas
obias76116863_obias
ocas66729633_o_cas
odas57230263_o_das
ohias84415573_ohias
okas85225393_o_kas
okras94410973_okras
ollas54218283_ollas
orcas75918623_orcas
osar46820953_o_sar
oses46641513_o_ses
ossia53710403_ossia
ousts55225703_ousts
paisas84317493paisas
pashas115117063pashas
passes86030473passes
passus83610293passus
pastas85422873pastas
pisses84525083pisses
poises84226543poises
polkas1239103polkas
poppas93710713poppas
posadas1037193posadas
posers84223973posers
poses74642763po_ses
posies84431433posies
posits85718713posits
posse74722273poss_e
possess9419123possess
posset84923253posset
possets94212773possets
possum1057953possum
possums1145753possums
postal84317533postal
postals93716373postals
posts75228783po_sts
prosses94019513prosses
psoas75012983_psoas
pusses84322843pusses
roasts64915413roasts
rooses65526233rooses
roosts64916323roosts
roses56445773ro_ses
rosets65819953rosets
roshis9311793roshis
rosins64521863rosins
rotas54827723ro_tas
rouses65436283rouses
rousts617016723rousts
salsas65316133salsas
sass45035623__sass
sasses64124393sasses
seas45755273__seas
sisses64520603sisses
skas85325713__skas
sobas74424253so_bas
socas74026183so_cas
sodas64123543so_das
sofas85320713so_fas
softas94410403softas
sojas124716393so_jas
somas76030373so_mas
soras55041013so_ras
souses64229243souses
soyas84520913so_yas
spas67036723__spas
susses64221053susses
tasses64826763tasses
teslas64212173teslas
toasts65914993toasts
toeas55726423to_eas
togas67823003to_gas
tolas54532773to_las
tongas74315523tongas
toras55540373to_ras
torses64727953torses
torsks10549123torsks
torsos64815733torsos
tortas64918253tortas
toshes94520103toshes
toss45637973to_s_s
tossed74215223tossed
tosser64215663tosser
tossers74713503tossers
tossup875293tossup
tossups964023tossups
touses64229673touses
tussah9356233tussah
tussahs10335113tussahs
tussal6288323tussal
tussar6369543tussar
tussars7359253tussars
tusses64921243tusses
tussis6379953tussis
vassal979243vassal
vassals1057953vassals
vestas95916683vestas
visas84317653_visas
vistas94513273vistas
vodkas1443543vodkas
volvas12447993volvas
wisses94619603wisses
worses95522953worses
worsts96014333worsts
wusses93314893wusses
yesses93615813yesses
yogas96615603yo_gas
zoeas145815613zo_eas
zoysias1943843zoysias

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.1401276364.3
2DLD Change Limit1127165165.09322131.6
3Display Results5165160.1563307.7
 (SQL Overall)1786915165.38933158.5
 
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.