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

207 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
godsons96666(None) 
godson857381godson_
bolsons969482bolsons
bosons85016652bo_sons
codons96119462cod_ons
dobsons1036202dobsons
foisons1047612foisons
gibsons1045042gibsons
godowns1234672godowns
godroons1045362godroons
godsend1084042godsend
godsends11113352godsends
goons65326772go__ons
gorgons938852gorgons
gossans836782gossans
gossoons944892gossoons
grisons838992grisons
odeons739022_odeons
podsols1056512podsols
poisons9310352poisons
arsons63917213_arsons
bisons83914373_bisons
blousons1054403blousons
bodkins1438313bodkins
bolson8410683bolson_
bonbons1139333bonbons
boons75031913bo__ons
borons85520543bo_rons
bosoms104913053bo_soms
boson76019733bo_son_
bostons9312903bostons
bosuns8439383bo_suns
boutons9310783boutons
cocoons11310563cocoons
codeins103715483codeins
codens94821013cod_ens
codlins104116243codlins
codon86522853cod_on_
cogons96818113co_gons
colons86028683co_lons
commons13311043commons
consols92914073consols
coons76737283co__ons
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
cousins9516003cousins
damsons1038013damsons
doblons1037043doblons
dobson936593dobson_
dodoes85716103dod_oes
dodos75819393dod_o_s
donjons1536733donjons
dons56048703__d_ons
ecdysons1442113ecdysons
eosins64419163eo_sins
foison948933foison_
gabions102410053gabions
gaboons10289903gaboons
gadroons1037013gadroons
gallons83015953gallons
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
gessoes838293gessoes
gibbons1234983gibbons
gibson935123gibson_
gipons9389603g_ipons
girons75014373g_irons
gluons738503g_luons
gnomons1035753gnomons
gobans94412043go_bans
goblins1039243goblins
goboes95914443go_boes
gobony1236913go_bony
gobos86219383go_bo_s
goddamns1341983goddamns
goddams1233983goddams
goddess1035263goddess
godding113911943godding
godets8410933god_ets
godhood1345143godhood
godhoods1444173godhoods
godless938403godless
godling103513403godling
godlings11367493godlings
godown1136033god_own
godroon946043godroon
gods65438043god___s
godship1445083godship
godships1544723godships
godwits1234133godwits
gogos77516523go_go_s
goldarns1043593goldarns
goldstone1194663goldstone
goldstones1294403goldstones
goldtone1084593goldtone
goldurns1042603goldurns
gombos114311093gombo_s
gonion73612833gonion_
gonofs10459863go_nofs
goods75124483go__ods
goofs94821003go__ofs
googols935483googols
gooks105422883go__oks
goon57236173go__on_
goony95519783go__ony
goops86620963go__ops
goos57644913go__o_s
gooses75723053goos_es
goosing93314083goosing
gorgon8310243gorgon_
gorhens1137183gorhens
gorses74723293gors_es
gossan747233gossan_
gossips1035903gossips
gossoon865663gossoon
governs1136103governs
gowans105512293go_wans
gowns95115103go__wns
grandsons1145123grandsons
grison7310103grison_
gudgeons11113943gudgeons
guenons836563guenons
guidons936623guidons
gyrons105511223g_yrons
hadrons113314303hadrons
hoddens12378803hoddens
hoddins12289373hoddins
hysons1237633_hysons
iodins74216523iod_ins
iodous7311503iod_ous
johnsons1842383johnsons
kelsons1137323kelsons
ladrons83813193ladrons
lessons73811023lessons
lodens74315063lod_ens
logions86211293logions
logons79818173lo_gons
loons55731723lo__ons
loosens716310953loosens
lotions74614763lotions
masons83916513_masons
mesons83215843_mesons
moderns1037963moderns
monsoons1047343monsoons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
motions94215003motions
moutons9410313moutons
nelsons738003nelsons
nodous7711333nod_ous
noons54125283no__ons
notions74014483notions
odeon6411483_odeon_
odious749933_odious
odors64514283_od_ors
onions64016433_onions
oodlins83210513oodlins
opsins8411713_opsins
orisons7310563orisons
orlons6411013_orlons
parsons93516873parsons
persons93717013persons
pocosons1266103pocosons
podsol946853podso_l
podzols1934683podzols
poison8312223poison_
pompons1338553pompons
pontons93315553pontons
poons75430973po__ons
potions93417423potions
prisons9313223prisons
radons74118533rad_ons
ramsons939563ramsons
reasons72514943reasons
redons75222183red_ons
rodeos75314503rodeo_s
ronions73313343ronions
ronyons10258433ronyons
rosins64521863ro_sins
seasons72614233seasons
soddens9348413soddens
sodoms989673sod_oms
solions7513753solions
solons65120023so_lons
sons46049553___sons
sponsons1045813sponsons
telsons739223telsons
tocsins939963tocsins
toons55027533to__ons
torsions839183torsions
torsos64815733torso_s
toyons95512133to_yons
udons65411463_ud_ons
unisons748423unisons
vodouns1134763vodouns
vodous1038603vod_ous
voduns1035053vod_uns
voudons1135323voudons
weasons102310583weasons
wontons103310533wontons
worsens104610263worsens
youpons12265983youpons
zoons144919693zo__ons

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.406440125.6
2DLD Change Limit1340272075.65623696.4
3Display Results2072070.0762723.7
 (SQL Overall)1786912076.13829112.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.