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 “gogos” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
gogos7751652(None) 
gobos86219371gobos
gogo69722831gogo_
goos57644911go_os
logos67225331logos
bigos85020012bigos
bogs75742752bog_s
bogus85616472bogus
bohos105618252bohos
bolos75531372bolos
bongos95316652bongos
boos67955032bo_os
boyos105418282boyos
bozos165216862bozos
cocos95624692cocos
cogon89120902cogon
cogons96818112cogons
cogs77340032cog_s
cohos105921852cohos
congos94219882congos
coos67456492co_os
dagos76419442dagos
dodos75819392dodos
doges75630162doges
dogs66440152dog_s
dojos135111792dojos
egos55821652_egos
fogs87035002fog_s
gages74529972gages
gags66441062gag_s
gigas75415582gigas
gigot74023072gigot
gigots83911952gigots
gigs66631182gig_s
giros65722652giros
gloggs935032gloggs
goads77022852goads
goals65521292goals
goas55239942go_as
goats65527302goats
gobo76126892gobo_
goboes95914442goboes
gobs76935572go_bs
gods65438042go_ds
goers65520252goers
goes55644092go_es
golds75421312golds
golfs95616102golfs
golosh1036462golosh
gombos114311092gombos
gongs74921612gongs
gonof95218652gonof
gonofs10459862gonofs
goo47754772go_o_
good66531802go_od
goods75124482goods
goof85436872go_of
goofs94821002goofs
googol835842googol
googols935482googols
gook96429602go_ok
gooks105422882gooks
goon57236172go_on
goons65326772goons
goop75829482go_op
goops86620962goops
goose65925902go_ose
goosy96018882go_osy
gores65740372gores
gorges85321892gorges
gorgon8310242gorgon
gorgons938852gorgons
gorms85619592gorms
gorps85316992gorps
gos47155132__gos
goths96513002goths
gouges86318692gouges
gouts64826172gouts
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
gregos847532gregos
grogs76319412grog_s
gyros95616482gyros
hobos106321352hobos
hoggs107212462hoggs
hogs87139662hog_s
homos105921782homos
jogs127129332jog_s
kobos115616892kobos
kolos94921212kolos
kotos95717692kotos
lobos75921842lobos
locos75822602locos
loges66534202loges
logo57931762logo_
logoi69715942logoi
logon615922312logon
logons79818172logons
logs57343112log_s
loos49051122lo_os
lotos54724632lotos
mogs75439332mog_s
mojos145314462mojos
mongos94318622mongos
monos75930862monos
moos66051302mo_os
mozos165516332mozos
noggs75811182noggs
nogs56534612nog_s
nolos54423352nolos
nomos75919742nomos
onos46229002_onos
polos76129912polos
pomos95321582pomos
poos65949112po_os
rotos56027882rotos
sagos66123872sagos
segos64919482segos
solos54830792solos
sorgos74514662sorgos
togas67823002togas
togs57242432tog_s
topos75726392topos
toros54336192toros
toyos87519142toyos
wogs86531402wog_s
woos76238802wo_os
yogas96615602yogas
yoghs125410592yoghs
yogis95617742yogis
zoos135828802zo_os

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 Filter178691538000.326548131.9
2DLD Change Limit538001344.45312081.7
3Display Results1341340.0801675.0
 (SQL Overall)1786911344.85936775.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.