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

170 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
gasbags113547(None) 
gasbag1035411gasbag_
casbahs1436462casbahs
gambas115817512gamba_s
garbage1138052garbage
garbages1238182garbages
garbagy1444242garbagy
kasbahs1634362kasbahs
ragbags1135112ragbags
ratbags1035762ratbags
abas68642083_a_ba_s
abbas95918643_abba_s
airbags1036293airbags
albas75925393_alba_s
ambage11510593_ambage
ambages1269623_ambages
assais6711963_assais
assays977903_assays
babas96325733ba_ba_s
bags76645503___bags
baobabs1044443baobabs
bashaws15347713bashaws
beanbags1342863beanbags
busbars1138153busbars
cabals104020153ca_bals
cabbage1446983cabbage
cabbages1537203cabbages
cabbagy1744013cabbagy
casabas1139983casabas
casas75327843cas_a_s
casbah1337903casba_h
cashaws15398573cashaws
casings104013513casings
casuals91410523casuals
darbars10510093darbars
debags104211063_debags
disbars10310323disbars
gabbard1336553gabbard
gabbards1445753gabbards
gabbart1248883gabbart
gabbarts1344063gabbarts
gabbers124612833gabbers
gabbles124415413gabbles
gabbros12124653gabbros
gabies93820723ga_bies
gables94222333ga_bles
gabs76740423ga_b__s
gags66441063g___ags
galago838903ga_lago
galagos938143ga_lagos
galahs105512673ga_lahs
galas65731643ga_la_s
galeas74618503galea_s
galyacs1335273galyacs
galyaks1534623galyaks
gamas85431353ga_ma_s
gamays126310903ga_mays
gamba106018513gamba__
gambade1336383gambade
gambades1435863gambades
gambado1344973gambado
gambados1444143gambados
gambes116318313gamb_es
gambias125010723gambias
gambirs12359073gambirs
gambits12399713gambits
gambles124016203gambles
gamboge1335583gamboge
gamboges1435653gamboges
gambols1238593gambols
gambs105721123gamb__s
gamings114610913gamings
gammas115714693gamma_s
gangbangs1442623gangbangs
gangs76222573ga__ngs
ganjahs18104003ganjahs
ganjas14149113ganja_s
garage8314513ga_rage
garages9314113ga_rages
garbagey1543373garbagey
garbles104016923garbles
garbs86321413garb__s
gascons10289103gascons
gaseous839503gaseous
gases65633993gas__es
gashes105725153gas_hes
gaskets12348153gaskets
gaskings14427473gaskings
gaskins123510773gaskins
gasless8319013gasless
gasman92911743gasma_n
gaspers105014133gaspers
gasps85415483gas__ps
gassers84714633gassers
gasses75724783gas_ses
gassings10438403gassings
gasters85624283gasters
gasts66628633gas__ts
gateaus866323gateaus
gatings95212823gatings
gavage1137193ga_vage
gavages1237683ga_vages
gavials1136603gavials
gayals1039513ga_yals
gaydars1235803gaydars
gazabos1944453gazabos
gazars164811553ga_zars
gimbals12257813gimbals
gobangs11385833g_obangs
gobans94412043g_obans
gossans836783gossans
graylags1372983graylags
gulags837543g_ulags
handbags15116363handbags
isbas71010393_isba_s
kababs14409763ka_babs
kabars124513953ka_bars
kanbans1337723kanbans
kasbah1535183kasba_h
kashas133311903kasha_s
kitbags1443883kitbags
lascars979013lascars
mailbags1343903mailbags
mambas125716243mamba_s
masas75630413mas_a_s
maskegs14375413maskegs
massage1039893massage
massages1159883massages
massas85116463massa_s
nasals63312463nas_als
nosebags1143593nosebags
padnags1135083padnags
pascals11610013pascals
pashas115117063pasha_s
passage1039803passage
passages1139513passages
pastas85422873pasta_s
postbags1345293postbags
rabats83116223ra_bats
ragbag1045463ragbag_
ragtags935373ragtags
rascals959663rascals
ratbag956563ratbag_
sabals84618863sa_bals
sabbats1138633sabbats
sags55948403__s_ags
sambals115213483sambals
sambars115113843sambars
sambas104219263samba_s
sandbags1296373sandbags
sashays1336333sashays
scags85520973__scags
seabags1037483seabags
shags95123863__shags
skags104316073__skags
slags66525903__slags
snags64421313__snags
stags66226743__stags
swags94921253__swags
tagrags936123tagrags
tambacs13219363tambacs
tambaks15218153tambaks
taskbars1452983taskbars
unsnags835463unsnags
vassals1057953vassals
wasabis1255363wasabis
washrags1543893washrags
wastage11109253wastage
wastages12109753wastages
yasmaks1633653yasmaks

Search took 9 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.1561145455.1
2DLD Change Limit1340271708.04616657.6
3Display Results1701700.0632698.4
 (SQL Overall)1786911708.26521620.2
 
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.