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

162 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
globated126575(None) 
gloated93511531glo_ated
globate1057821globate_
lobated102610941_lobated
bilobated1444972bilobated
bloated104513432blo_ated
floated113312702flo_ated
gloater83711012glo_ater
globed104811762glob__ed
glouted9429712glo_uted
lobate82915242_lobate_
located103114182_located
probated13410862probated
abated95918453__abated
alated75625143al__ated
allocated1248093allocated
bated85935533___bated
bilobate1247033bilobate_
bleated104015973bl_eated
bloater94013423blo_ater
blobbed11366563blob_bed
blotted103911833blo_tted
bloviated1573623bloviated
boated94221973_bo_ated
borated104116363_borated
bromated1339173bromated
cleated103417843cl_eated
cloaked14368543clo_aked
closeted1135613closeted
clotted104011823clo_tted
clouted104212163clo_uted
coated94927043_co_ated
cohobated1744883cohobated
collated113615063collated
colocated1439613colocated
combated1539823combated
conglobated1753003conglobated
debated113916083_debated
doated84118183_do_ated
donated93513863_donated
elated74725823el__ated
elevated12118293elevated
elongated1144283elongated
floatel10308013flo_atel
floater104413353flo_ater
floreated1346573floreated
floriated1347023floriated
flouted113210813flo_uted
foliated1249913foliated
galeated104111573galeated
gated75329773g___ated
gelated93615633g_elated
gemmated14336293gemmated
gestated102910573gestated
ghosted1236273gho_sted
gibbeted1492783gibbeted
gimbaled14104173gimbaled
glabrate1146033glabrate_
glaciated1365753glaciated
glared84715193gl__ared
glazed174711773gl__azed
gleamed11327933gl_eamed
gleaned9349423gl_eaned
glebae9407613gleba_e_
gleeted9379323gl_eeted
glinted9399373gl_inted
gloat65427683glo_at__
gloaters9288863glo_aters
gloats74515423glo_at_s
global937663globa__l
globalised1443213globalised
globalized2344113globalized
globally1444613globally
globbier1334243globbier
globe84917013glob__e_
globes94314543glob__es
globoid1145973glob_oid
globose1035543globose_
globule1034383globule_
globules1135413globules
glommed13265443glo_mmed
gloomed11337413glo_omed
glopped13347613glo_pped
gloried9169513glo_ried
glossed94410073glo_ssed
gloved114811873glo__ved
glowed114913833glo__wed
glowered1345753glowered
glozed173711223glo__zed
glutted937243gl_utted
goaded94913713g_o_aded
goaled85014363g_o_aled
goatee73219533g_o_atee
goateed9307063g_o_ateed
gobbed124613883g_ob_bed
gobbled134010253g_obbled
gowaned1235763g_owaned
gradated1157433gradated
grated84523923g__rated
groaned9259973gro_aned
grouted94111503gro_uted
guttated10266873guttated
gyrated12428413g_yrated
iodated9310023_iodated
isolated9410523isolated
labiated11109303_labiated
lanated8313203_lanated
lated65240673_l__ated
legated92513983_legated
librated113110313_librated
ligated92414143_ligated
loaded84616873_lo_aded
loafed104011153_lo_afed
loamed94414613_lo_amed
loaned73816293_lo_aned
loathed11419443_lo_athed
lobately1344013_lobately
lobbed113114613_lob_bed
lobbied12337173_lobbied
lobed86022133_lob__ed
lobster9288853_lobster
lobulated12106423_lobulated
locate83919843_locate_
locater93113603_locater
locates93218813_locates
lofted103811893_lo_fted
looted74421113_lo_oted
lotted74222403_lo_tted
louted74920693_lo_uted
lunated8310823_lunated
luxated1535713_luxated
lyrated11388473_lyrated
moated94819003_mo_ated
niobate937703niobate_
niobates1037283niobates
notated82713663_notated
orated74221503__orated
ozonated1864593ozonated
phonated1447893phonated
placated1338453placated
plated95225773pl__ated
pleated103816633pl_eated
plicated13310643plicated
plotted104612373plo_tted
probate11414483probate_
probates12414283probates
pronated11414053pronated
prorated11513713prorated
rebated103619703_rebated
relocated12710813relocated
rotated82715293_rotated
slated75028313sl__ated
slotted84613883slo_tted
solated83618023_solated
solvated12237443solvated
togated94410663_togated
ululated947663ululated
unabated11310133unabated
unbated103317733_unbated
unlocated1238383unlocated
violated1237883violated
zonated173310533_zonated

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621626.22023498.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.68626726.1
 
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.