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

201 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
gossans83678(None) 
gossan747231gossan_
dossals8379292dossals
fossas94610702fossa_s
glossas8438192glossa_s
gobans94412042go_bans
godsons966662godsons
gossips1035902gossips
gossoons944892gossoons
gowans105512292go_wans
messans92710462messans
assais6711963_assais
assays977903_assays
bogans95714813bo_gans
bolsons969483bolsons
bosons85016653bo_sons
bosses85925403boss_es
bossies94116833bossies
bossing103714603bossing
bostons9312903bostons
bosuns8439383bo_suns
corbans11313173corbans
corsacs1139013corsacs
cosigns1047513cosigns
cossack1545823cossack
cossacks1645223cossacks
cossets95014283cossets
costars94218013costars
cotans81317923co_tans
cousins9516003cousins
desmans1039003desmans
dobsons1036203dobsons
dolmans10479683dolmans
dorsals84110843dorsals
dossal75510303dossa_l
dossels85511603dossels
dossers84516233dossers
dosses76126273doss_es
dossils8669773dossils
dossing93313273dossing
eosins64419163eo_sins
essays965653_essays
foisons1047613foisons
fossa85812633fossa__
fossae95510373fossa_e
fossate10388603fossate
fosses96022083foss_es
fossils10379013fossils
gasbags1135473gasbags
gascons10289103gascons
gaskins123510773gaskins
gasman92911743gasman_
gassers84714633gassers
gasses75724783gass_es
gassing94216333gassing
gassings10438403gassings
germans1079473germans
gessoes838293gessoes
gibsons1045043gibsons
glans65125833g__lans
gleans75014743g_leans
glossa7529163glossa__
glossae8477283glossa_e
glossal8447053glossa_l
glossary1243373glossary
glossers9319053glossers
glosses84014123gloss_es
glossies93311253glossies
glossina9275543glossina
glossinas10214143glossinas
glossing10278883glossing
glucans1045293glucans
glycans1344233glycans
goads77022853go__ads
goals65521293go__als
goannas836223goannas
goas55239943go__a_s
goats65527303go__ats
goban84414073go_ban_
gobang10376703go_bang
gobangs11385833go_bangs
goblins1039243goblins
goddamns1341983goddamns
goddams1233983goddams
godowns1234673godowns
godsend1084043godsend
godsends11113353godsends
godson857383godson_
goldarns1043593goldarns
gonads84511733go_nads
goons65326773go__ons
goorals838703goorals
gooses75723053goos_es
goosing93314083goosing
gorals76917653go_rals
gorgons938853gorgons
gorhens1137183gorhens
gormand1157453gormand
gormands1266563gormands
gorses74723293gors_es
goshawk1862423goshawk
goshawks1962053goshawks
gosling93312403gosling
goslings10297553goslings
gospels1035593gospels
gossamer1143633gossamer
gossamers1243333gossamers
gossip946433goss_ip
gossipy1343953gossipy
gossoon865663gossoon
governs1136103governs
gowan95415743go_wan_
gowany13457493go_wany
gowns95115103go__wns
grans64832543g__rans
grisons838993grisons
groans74815063g_roans
grossers94410973grossers
grosses84517683gross_es
grossing103111063grossing
guans64419443g__uans
gussets837443gussets
gussies82813303gussies
hessians1145053hessians
hogans105914313ho_gans
honans94814503ho_nans
hostas94515823hosta_s
hussars10326983hussars
inspans937803inspans
jessant1438443jessant
jordans1566833jordans
josses135117683joss_es
koans95818623ko__ans
lessens7409383lessens
lessons73811013lessons
loans56026463lo__ans
lochans1248833lochans
logans76319063lo_gans
longans84510813longans
loosens716310953loosens
lorans65117603lo_rans
losses65925233loss_es
lyssas935443lyssa_s
massas85116463massa_s
messan83912063messan_
missals93914423missals
missays124010253missays
moans74624373mo__ans
morgans10310123morgans
mossers94116193mossers
mosses85527683moss_es
mossing103915423mossing
nonfans1037533nonfans
oceans81211003_oceans
octans81411143_octans
opsins8411713_opsins
organs7912913_organs
ossa43714163_ossa__
osseins736133_osseins
paesans93312693paesans
paisans93614753paisans
passant9813943passant
pissant91012503pissant
pissants1097363pissants
poisons9310353poisons
posses85128803poss_es
possess9419123possess
possets94212773possets
possums1145753possums
postals93716373postals
postins93721203postins
ptisans9317363ptisans
roans54926443ro__ans
romans84620243ro_mans
rosins64521863ro_sins
rowans95715343ro_wans
sans45153363___sans
scans74625103__scans
solans64122493so_lans
soldans83210403soldans
somans84619303so_mans
soudans8309353soudans
sovrans1036483sovrans
sowans94215893so_wans
spans74528733__spans
swans84625013__swans
tocsins939963tocsins
tolans64319273to_lans
tomans85419133to_mans
tossers74713503tossers
tosses65225393toss_es
tossing83612563tossing
tossups964023tossups
toucans937583toucans
tussahs10335113tussahs
tussars7359253tussars
vassals1057953vassals
wessand1144833wessand
wessands1243673wessands
womans114613653wo_mans
worsens104610263worsens

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.1401276364.3
2DLD Change Limit1340272015.81323056.4
3Display Results2012010.0762644.7
 (SQL Overall)1786912016.02929638.6
 
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.