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

201 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
globate105782(None) 
globated1265751globated
lobate82915241_lobate
bilobate1247032bilobate
glabrate1146032glabrate
glebae9407612gleba_e
gloat65427682glo_at_
gloated93511532glo_ated
gloater83711012glo_ater
gloats74515422glo_ats
global937662globa_l
globe84917012glob__e
globose1035542globose
globule1034382globule
lobated102610942_lobated
locate83919842_locate
niobate937702niobate
probate11414482probate
abate76627843__abate
alate55340323al__ate
albata839333al_bata
albite8313313al_bite
allocate10411023allocate
barbate11314543barbate
bate66552423___bate
bilobated1444973bilobated
blate75933783bl__ate
bloat75229923blo_at_
bloated104513433blo_ated
bloater94013423blo_ater
bloats85215763blo_ats
bloviate1384913bloviate
borate85026153_borate
bromate11313553bromate
celibate1259313celibate
chlorate133112693chlorate
cholate122114933cholate
clavate1238713clavate
climate11312833climate
clodpate1344083clodpate
cohobate1547013cohobate
collate92919683collate
colocate12313433colocate
comate104124843_comate
conglobate1563653conglobate
debate94419193_debate
donate73619503_donate
elate55335883el__ate
elevate101110373elevate
elongate945613elongate
eluate62315433el_uate
float85928573flo_at_
floated113312703flo_ated
floatel10308013flo_atel
floater104413353flo_ater
floats96816253flo_ats
floaty124210943flo_aty
flokati1443483flokati
florae94713883flora_e
flotage1136683flotage
flowage1435723flowage
folate93320393_folate
foliate10513533foliate
galeate83916783galeate
gallate83417123gallate
galopade1243953galopade
gambade1336383gambade
garbage1138053garbage
gate55746573g___ate
gelate73421253g_elate
gemmate12418383gemmate
gestate83614073gestate
glace87420153gl__ace
glaciate1168073glaciate
glade75121963gl__ade
gladiate1057053gladiate
glare65222953gl__are
glaze155418163gl__aze
gleba83910243gleba__
glebe85016443gleb__e
gliomata1143543gliomata
gloam86015943glo_a_m
gloams95210663glo_ams
gloaters9288863glo_aters
glob76623393glob___
globalise1245153globalise
globalize2144763globalize
globally1444613globally
globbier1334243globbier
globby1434683glob_by
globed104811763glob_ed
globes94314543glob_es
globin9309723glob_in
globing113210003globing
globins10278953globins
globoid1145973globoid
globous1036503globous
globs85616403glob__s
globules1135413globules
glomerate1245673glomerate
glossae8477283glossae
glost65422933glo_st_
glosts74513813glo_sts
glottal835103glottal
glout65925813glo_ut_
glouted9429713glo_uted
glouts74414713glo_uts
glove94516293glo__ve
gloze154815983glo__ze
gluconate1244793gluconate
glute66020903gl__ute
goat56250833g_o_at_
goatee73219533g_o_atee
goats65527303g_o_ats
goban84414073g_oba_n
gobang10376703g_obang
gobans94412043g_obans
gobbet114214443g_obbet
gobble113512983g_obble
goblet93219483g_oblet
goliath1145933goliath
gradate9511233gradate
grate64932883g__rate
groat65531973gro_at_
groats74816653gro_ats
guttate8328903guttate
gyrate104912523g_yrate
iodate7313503_iodate
isobare946343isobare
isobath1244613isobath
isolate7313923isolate
kilobase1453873kilobase
kilobyte1742933kilobyte
labiate91313573_labiate
lanate6421263_lanate
late47560483_l__ate
legate72917453_legate
librate93214233_librate
ligate72519253_ligate
limbate1139213limbate
loath84918603_lo_ath
loathe94211383_lo_athe
lobar7313013_loba_r
lobately1344013_lobately
lobe65535363_lob__e
lobster9288853_lobster
lobulate1078833_lobulate
lobule82910063_lobule
locale83915653_locale
located103114183_located
locater93113603_locater
locates93218813_locates
lotte54923853_lo_tte
lovage1037353_lovage
lovat8321043_lovat_
lovats939073_lovats
lunate6316043_lunate
luxate1338083_luxate
lyrate94112103_lyrate
lysate9388103_lysate
neonate7311333neonate
niobates1037283niobates
niobite937953niobite
notate63217863_notate
oblate82214743__oblate
obovate1235463obovate
odonate848403odonate
oleate6318883ol_eate
orate55133303__orate
ovate84214393__ovate
ozonate1646863ozonate
phonate12411813phonate
phorate12413363phorate
placate11312433placate
planate9314573planate
plate74635113pl__ate
plicate11314513plicate
plumate1149803plumate
probated13410863probated
probates12414283probates
prolate9419793prolate
pronate9418873pronate
prorate9418733prorate
rebate84424113_rebate
relocate10713533relocate
rotate63320343_rotate
slate55438283sl__ate
solate64526073_solate
solvate102710213solvate
sorbate9311733sorbate
stomate9313123stomate
stylobate1442763stylobate
togate74515683_togate
toluate7159343toluate
trilobate1145433trilobate
tubate82813173_tubate
ululate749963ululate
violate10311553violate
volvate13317993volvate
zlote143912943zlo__te
zonate154114923_zonate

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 Filter1786911340270.440406115.9
2DLD Change Limit1340272015.64023763.7
3Display Results2012010.0633190.5
 (SQL Overall)1786912016.14329088.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.