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

268 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
gossan74723(None) 
gossans836781gossans
dossal75510302dossal
fossa85812632fossa_
fossae95510372fossae
fossas94610702fossas
gasman92911742gasman
glossa7529162glossa_
glossae8477282glossae
glossal8447052glossal
glossas8438192glossas
goban84414072go_ban
godson857382godson
gossip946432gossip
gossoon865662gossoon
gowan95415742go_wan
messan83912062messan
ossa43714162_ossa_
assai5711543_assai
assay8710283_assay
bogan87519003bo_gan
bolson8410683bolson
bonsai838463bonsai
boson76019733bo_son
boss65938343boss__
bossed94816533bossed
bosses85925403bosses
bossing103714603bossing
bossy105515973boss_y
boston8513043boston
bosun75113593bo_sun
bowman13129853bowman
busman10310253busman
byssal1134993byssal
corban10314693corban
corsac10410173corsac
cosign958783cosign
coss66143493coss__
cossack1545823cossack
cosset84125863cosset
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
cotan71521783co_tan
cousin8517163cousin
cowman13910373cowman
desman9311693desman
dobson936593dobson
dolman95312403dolman
dorsa64617283dorsa_
dorsad8408973dorsad
dorsal74613943dorsal
doss56235043doss__
dossals8379293dossals
dossed84516633dossed
dossel74813643dossel
dosser74417973dosser
dosses76126273dosses
dossil75110903dossil
dossing93313273dossing
eolian6312593eolian
eonian6311833eonian
eosin55220923eo_sin
essay867623_essay
foeman11311233foeman
foison948933foison
foss76431643foss__
fossate10388603fossate
fosse86119463foss_e
fosses96022083fosses
fossil9379353fossil
gagman103811243gagman
gan48060133g___an
gasbag1035413gasbag
gascon9339723gascon
gaskin113610583gaskin
gasmen93111563gasmen
gassed85217633gassed
gasser75017773gasser
gasses75724783gasses
gassing94216333gassing
gassy95514023gass_y
german9611983german
gesso649603gess_o
gibson935123gibson
glassman1145183glassman
glean65818203g_lean
gloss64319623gloss__
glossary1243373glossary
glossed94410073glossed
glosser83410813glosser
glosses84014123glosses
glossina9275543glossina
glossing10278883glossing
glossy10549003gloss_y
glucan936183glucan
glycan1234903glycan
goa47343803go__a_
goad66830983go__ad
goal55829303go__al
goanna736653goanna
goas55239943go__as
goat56250833go__at
gobang10376703go_bang
gobans94412043go_bans
goblin939503goblin
gobs76935573gobs__
goddam1145163goddam
goddamn1242673goddamn
godown1136033godown
gods65438043gods__
godsend1084043godsend
godsons966663godsons
goes55644093goes__
goldarn944383goldarn
golden84411153golden
gonad75216053go_nad
gonia64117533gonia_
gonion73612833gonion
goodman1135933goodman
goon57236173go__on
gooral7310463gooral
goos57644913goos__
goose65925903goos_e
goosed86817033goosed
gooses75723053gooses
goosey105913513goosey
goosing93314083goosing
goosy96018883goos_y
goral65125753go_ral
gorgon8310243gorgon
gorhen1038893gorhen
gormand1157453gormand
gorse65926813gors_e
gorses74723293gorses
gorsy95915783gors_y
gos47155133go_s__
gosh86123423go_s_h
goshawk1862423goshawk
gosling93312403gosling
gospel936533gospel
gossamer1143633gossamer
gossips1035903gossips
gossipy1343953gossipy
gossoons944893gossoons
gotten73410113gotten
govern1036823govern
gowans105512293go_wans
gowany13457493go_wany
gown85724073go__wn
gownsman1443453gownsman
goys86328413goys__
gran56335013g__ran
grison7310103grison
groan65618423g_roan
gross65421693gross__
grossed93812253grossed
grosser84313143grosser
grosses84517683grosses
grossing103111063grossing
grossly1175983grossly
guan55325583g__uan
gunman9299453gunman
gusset7316433gusset
gussie72910153gussie
gussy95314323guss_y
hessian1035853hessian
hogan97817703ho_gan
honan85319773ho_nan
hosen85623883ho_sen
hosta85917833hosta_
hostas94515823hostas
hussar9317283hussar
inspan837513inspan
jessant1438443jessant
jordan1468063jordan
joss115925593joss__
josses135117683josses
koan85425033ko__an
koss85224813koss__
lessen64212433lessen
lesson64412043lesson
loan47436453lo__an
lochan1139093lochan
loessal744393loessal
logan68123283lo_gan
longan75612363longan
loosen66615963loosen
loran55925093lo_ran
loss45337963loss__
losses65925233losses
lossy85214643loss_y
lyssa835713lyssa_
lyssas935443lyssas
massa75518923massa_
massas85116463massas
mesian84315503mesian
messans92710463messans
messman1137283messman
missal84314903missal
missay114112143missay
moan65832023mo__an
morgan9311373morgan
moshav1446053moshav
moss67641033moss__
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mossing103915423mossing
mosso74715183moss_o
mossy105217063moss_y
nonfan948293nonfan
nonman8412363nonman
ocean71212963_ocean
octan71313483_octan
opsin7613473_opsin
organ6915393_organ
osar46820953_o_sar
ossein636593_ossein
ossia53710403_ossia
owsen84210193_owsen
paesan85114093paesan
paisan84417073paisan
passant9813943passant
pissant91012503pissant
poison8312223poison
posse74722273poss_e
posses85128803posses
posset84923253posset
possum1057953possum
postal84317533postal
postin83521033postin
postman112410043postman
potman102813573potman
ptisan8417973ptisan
roan47234203ro__an
rodman949713rodman
rodsman1036653rodsman
roman75424823ro_man
rosin55325313ro_sin
rowan85418733ro_wan
scan65530453__scan
socman1039813socman
solan55328153so_lan
soldan73511853soldan
soman75024903so_man
soudan73210353soudan
sovran937153sovran
span65234663__span
swan76631313__swan
tocsin8311003tocsin
tolan55124013to_lan
toman75724053to_man
toss45637973toss__
tossed74215223tossed
tosser64215663tosser
tosses65225393tosses
tossing83612563tossing
tossup875293tossup
toucan838193toucan
tussah9356233tussah
tussal6288323tussal
tussar6369543tussar
vassal979243vassal
wessand1144833wessand
woman105818003wo_man
worsen95513873worsen

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162685.97018880.4
3Display Results2682680.0763526.3
 (SQL Overall)1786912686.18628886.4
 
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.