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

115 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
globules113541(None) 
globule1034381globule_
lobules92510811_lobules
globes94314542glob__es
globular1143382globular
globulars1242452globulars
globulin1144192globulin
globulins1244172globulins
gobbles123512582g_obbles
lobule82910062_lobule_
locules92812602_locules
barbules1238043barbules
blouses94014463blo_uses
bobbles104514913_bobbles
boules84925973_bo_ules
ciboules1244533ciboules
clonuses1057133clonuses
cloques18268563cloqu_es
closures10228953closures
clotures10299023clotures
cobbles133814823_cobbles
cobles104622883_cob_les
colobuses1346133colobuses
doubles103113353_doubles
floccules1642853floccules
gabbles124415413g_abbles
gables94222333g_ab_les
gambles124016203gamb_les
garbles104016923garb_les
gemmules13183213gemmules
ghoulies1235393gho_ulies
ghouls1036043gho_ul_s
glandules1144253glandules
glebeless1242953glebeless
glebes95512243gleb__es
global937663global__
globalise1245153globalise
globalises1354593globalises
globalism1445273globalism
globalist1256763globalist
globalizes2244643globalizes
globally1444613globally
globate1057823globate_
globated1265753globated
globbier1334243globbier
globbiest1444023globbiest
globe84917013glob__e_
globed104811763glob__ed
globins10278953glob_ins
globoids1244413globoids
globose1035543globose_
globous1036503glob_ous
globs85616403glob___s
glomerules1352473glomerules
glomus9468093glomu__s
glories81915913glo_ries
glorioles1044263glorioles
glosses84014123glo_sses
glossies93311253glossies
glouted9429713glo_uted
glouts74414713glo_u_ts
gloves104115183glo__ves
glowflies1642893glowflies
glozes164313353glo__zes
glues65125683gl__u_es
glumes94516813gl__umes
glutes74517673gl__utes
gobble113512983g_obble_
gobbled134010253g_obbled
gobbler123310023g_obbler
gobblers13308343g_obblers
gobies95418063g_ob_ies
goblet93219483g_ob_let
goblets103210183g_ob_lets
goboes95914443g_ob_oes
goggles103510793g_oggles
gouges86318693g_o_uges
grabbles13339893grabbles
granules939933granules
gribbles13307363gribbles
grouses84616543gro_uses
guayules1243223guayules
gules64831043g___ules
hobbles143313783_hobbles
joules134116823_jo_ules
ligules82210923_ligules
lobbies113612463_lobbies
lobes75331003_lob__es
lobular936663_lobular
lobulose1044033_lobulose
locales93715093_locales
locule83412033_locule_
loculed10317653_loculed
loculus9296973_loculus
lotuses74011253_lotuses
louies64525103_lo_uies
loupes84918053_lo_upes
louses66230283_lo_uses
lunules738953_lunules
mobiles112813123_mobiles
modules102511003_modules
nobbles114014523_nobbles
nobles83319723_nob_les
nodules8269703_nodules
oboles83815833__oboles
ovules938223__ovules
plumules1234663plumules
robles85321693_rob_les
roubles93413513_roubles
solubles1065893solubles
sporules1037703sporules
troubles1057203troubles
tubules9310233_tubules
wobbles143412433_wobbles
zonules1647793_zonules

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621157.09320606.5
3Display Results1151150.0502300.0
 (SQL Overall)1786911157.29924481.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.