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

176 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
globbier133424(None) 
slobbier1254631slobbier
clobber13378162clobb_er
clubbier1434832clubbier
cobbier133410162_cobbier
flabbier1534092flabbier
gabbier12379632g_abbier
glibber1235162glibb_er
globbiest1444022globbiest
gloomier1135092gloomier
gloppier1354672gloppier
glossier9358202glossier
gobbler123310022g_obbler
grabbier13316652grabbier
grubbier13344752grubbier
knobbier1652702knobbier
lobber104016602_lobb_er
lobbied12337172_lobbied
lobbies113612462_lobbies
lobbyer1433912_lobbyer
nobbier11309162_nobbier
slobber11388902slobb_er
snobbier1234632snobbier
blabber10418923blabb_er
blobbed11366563blobb_ed
blobbing12246923blobbing
blockier1666133blockier
bloodier1136823bloodier
bloomier1275783bloomier
blottier10336413blottier
blousier1055663blousier
blowier1248943blo_wier
blowsier1335063blowsier
blowzier2233413blowzier
blubber10399293blubb_er
bobber95016743_bobb_er
bobbies103714563_bobbies
chubbier1733893chubbier
clabber134210113clabb_er
clobbers14397513clobb_ers
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
clubber13319593clubb_er
cobber124116843_cobb_er
cobbler133311823_cobbler
crabbier14326803crabbier
dobber114015423_dobb_er
dobbies124113063_dobbies
floatier1136983floatier
flockier1745343flockier
floppier1554633floppier
flossier11326973flossier
flubber14287713flubb_er
gabber114916603g_abb_er
gabbler124013303g_abbler
gambier124711973g_ambier
ghostier1235383ghostier
gibber114112863g_ibb_er
glacier103911303gl_acier
gladier93810993gl_adier
gladlier1034343gladlier
glairier944843glairier
glarier84112213gl_arier
glassier9289083glassier
glazier17409353gl_azier
gleamier1144913gleamier
gleetier934913gleetier
glintier945703glintier
glitzier1833593glitzier
gloater83711013glo_ater
globate1057823globate_
globated1265753globated
globby1434683globb__y
globe84917013glo_b_e_
globed104811763glo_b_ed
globes94314543glo_b_es
globin9309723glo_bi_n
globing113210003glo_bing
globins10278953glo_bins
globoid1145973globoi_d
globoids1244413globoids
globose1035543globose_
globular1143383globular
globule1034383globule_
globules1135413globules
gloried9169523glo_ried
glories81915923glo_ries
glorifier1344233glorifier
glosser83410813glo_sser
glossies93311253glossies
glover104513533glo__ver
glower105114933glo__wer
gluier7310263gl__uier
glumpier1334873glumpier
gobbed124613883g_obb_ed
gobbet114214443g_obb_et
gobbing132910703g_obbing
gobble113512983g_obble_
gobbled134010253g_obbled
gobblers13308343g_obblers
gobbles123512583g_obbles
gobies95418063g_o_bies
godlier938893g_odlier
goober93911743g_oob_er
goodlier1035793goodlier
goofier11339313g_oofier
gooier73516213g_o_oier
goonier83612843g_oonier
goopier103910573g_oopier
goosier83512563g_oosier
gorier73719373g_o_rier
gorsier83811073g_orsier
goutier82612353g_outier
grabber12389763grabb_er
grabbler13377693grabbler
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grottier9316673grottier
groutier9297173groutier
growlier1234883growlier
grubber12417913grubb_er
hobber134114633_hobb_er
hobbies143813343_hobbies
hobbler143710403_hobbler
jobber173813353_jobb_er
knobblier1741923knobblier
knubbier1642513knubbier
lambier113611643_lambier
libber104414013_libb_er
limbier11349113_limbier
loamier9349163_loamier
lobbed113114613_lobb_ed
lobbers113713943_lobb_ers
lobbing123110913_lobbing
lobbyers1533193_lobbyers
lobster9288853_lobster
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
loobies93814103_loobies
loonier73312683_loonier
loopier93711193_loopier
loppier11369723_loppier
lousier72411623_lousier
lowlier10338903_lowlier
lubber104214623_lubb_er
mobber123613463_mobb_er
nobbler113211183_nobbler
nubbier11308133_nubbier
orbier839993__orbier
plottier10327263plottier
ribbier1137593_ribbier
robber103916533_robb_er
scabbier1435133scabbier
shabbier1535183shabbier
slabber113311393slabb_er
slobberer13153443slobberer
slobbers12398523slobb_ers
slobbery15375663slobb_ery
slobbiest1345093slobbiest
slobbish1544263slobbish
sloppier1255713sloppier
sloshier1135283sloshier
slubber113010763slubb_er
snubbier1244993snubbier
sobber104016593_sobb_er
stubbier1235353stubbier
swobber14336543swobb_er
tubbier11237743_tubbier
webbier1445423_webbier
wobbler14329823_wobbler
wobblier15325203_wobblier
wombier1436543_wombier

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.423422437.4
2DLD Change Limit1461621766.25023385.9
3Display Results1761760.0762315.8
 (SQL Overall)1786911766.74926476.7
 
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.