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

186 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
gobangs1138583(None) 
gobang10376701gobang_
gobans94412041goban_s
bangs85627782__bangs
gangs76222582g__angs
goban84414072goban__
goings84911522go_ings
gongs74921612go__ngs
gowans105512292gowan_s
orangs74116032_orangs
probangs13256212probangs
robands10219862robands
bags76645503__ba_gs
bands85233433__bands
banes74945583__banes
bang74837013__bang_
banks115527903__banks
banns75321233__banns
bans66555143__ban_s
bhangs12449663_bhangs
bodings113711653bodings
bogans95714813bogan_s
boings96416873bo_ings
bombings15266493bombings
bongs87828423__bongs
boranes93720403boranes
borings103614243borings
bowings133612003bowings
boxings17429163boxings
bungs85323863__bungs
cabanas112413033cabanas
changs125215373_changs
clangs95113613_clangs
cobalts1139203cobalts
combings15348323combings
comings124013533comings
copings124111843copings
corbans11313173corban_s
cotans81317923cotan_s
covings134511243covings
cowbanes1537423cowbanes
dangs75623213__dangs
debags104211063deba_gs
defangs1235363defangs
dogbanes1245433dogbanes
doings84913183do_ings
dongs76525813do__ngs
dopants1038433dopants
dopings11408783dopings
embanks15295703embanks
fangs96224083__fangs
foxings18446963foxings
gags66441063g__a_gs
galanga936023galanga
galangas1046173galangas
gamings114610913gamings
gang66031983g__ang_
gangbangs1442623gangbangs
gasbags1135473gasba_gs
gatings95212823gatings
gelants82611443gelants
giants74713503g_iants
gibing103712353gibing_
gitanos837173gitanos
glands85314403g_lands
glans65125833g_lan_s
gleans75014743glean_s
globing113210003globing_
globins10278953globin_s
goads77022853go_a_ds
goals65521293go_a_ls
goanna736653go_anna
goannas836223goannas
goas55239943go_a__s
goats65527303go_a_ts
gobbets12327643gobbets
gobbing132910703gobbing_
gobbles123512583gobbles
gobies95418063gob_ies
goblets103210183goblets
goblins1039243goblins
goboes95914443gob_oes
gobonee1077783gobonee
gobony1236913gobon_y
gobos86219383gob__os
gobs76935573gob___s
godlings11367493godlings
going75218493go_ing_
golfings13304873golfings
gonads84511733gona_ds
gong66827193go__ng_
goons65326773go_on_s
gorals76917653gora_ls
goring84119573goring_
gormands1266563gormands
goslings10297553goslings
gossans836783gossan_s
gowan95415743gowan__
gowaned1235763gowaned
gowany13457493gowan_y
gowns95115103go_wn_s
grands84218243g_rands
grange83716203g_range
granges93516523g_ranges
grans64832543g_ran_s
grants73722473g_rants
groans74815063groan_s
guanos73811993g_uanos
guans64419443g_uan_s
gulags837543gula_gs
gybing13355933gybing_
hangs95726733__hangs
hogans105914313hogan_s
honans94814503honan_s
hongs95126203ho__ngs
kiangs11378363_kiangs
koans95818623ko_an_s
liangs74410593_liangs
loans56026463lo_an_s
logans76319063logan_s
longs65527063lo__ngs
lorans65117603loran_s
losings82810623losings
lowings113710073lowings
moans74624373mo_an_s
mowings13328483mowings
nonbanks1445033nonbanks
nosings8349593nosings
obas65730933_oba__s
oblongs1033533_oblongs
oolongs845953oolongs
orang65119943_orang_
orange74016323_orange
oranges84215333_oranges
orangy105111233_orangy
ourangs8318503ourangs
pangs84628673__pangs
parangs104314383parangs
penangs10268373penangs
pinangs10267793pinangs
poblanos1244993poblanos
pongs85526343po__ngs
prangs94816233_prangs
probands13228393probands
probang12278383probang_
rehangs1137563rehangs
ribands10208393ribands
roans54926443ro_an_s
robalos937683robalos
roband92310723roban_d
robing93618003robing_
robins83617453robin_s
romanos94311483romanos
romans84620243roman_s
rovings11439493rovings
rowans95715343rowan_s
rowings113710363rowings
satangs8479713satangs
shebangs1443593shebangs
slangs75615343_slangs
sobas74424253soba__s
solands84412343solands
solanos74412853solanos
solans64122493solan_s
somans84619303soman_s
sonants7511233sonants
songs67725553so__ngs
sorings83817253sorings
sowans94215893sowan_s
sprangs104610053sprangs
stangs75018173_stangs
tangs65028363__tangs
tolanes74216313tolanes
tolans64319273tolan_s
tomans85419133toman_s
tongs65928473to__ngs
tubings10336483tubings
twangs10358103_twangs
unbans81912623unban_s
unhangs1136203unhangs
vangs96319603__vangs
whangs13439723_whangs
womans114613653woman_s
wrangs104611913_wrangs
yangs95618703__yangs
youngs1035383yo_ungs

Search took 8 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.533335255.2
2DLD Change Limit1340271866.95319276.1
3Display Results1861860.0632952.4
 (SQL Overall)1786911867.54923670.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.