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

235 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
glitzy1940478(None) 
glitz154916371glitz_
blitz165318132blitz_
ditzy186513282_ditzy
glazy187410982gl_azy
glibly1236292glibly
glinty106910692glinty
glitch12286352glitch
glitchy16283082glitchy
glitzed18375492glitzed
glitzes17367562glitzes
gritty10338402gritty
klutzy2243002klutzy
ritzy175611162_ritzy
slitty9329162slitty
agility1148653agilit_y
alit46155693alit__
amity10416093amit_y
bitsy104511303_bitsy
bitty106119173_bitty
blimey13468453blimey
blimy125212823bli_my
blintz1788843blintz_
blintze1833903blintze
blite76225353blit_e
blites84721213blites
blithe115810863blithe
blitzed19336533blitzed
blitzer18447663blitzer
blitzes18408703blitzes
blotty11178343blotty
blowzy23516673blowzy
chintzy24364223chintzy
chitty14329433chitty
city95122633_cit_y
cliffy17435243cliffy
clingy12659063clingy
cliquy20324713cliquy
clitic103315053clitic
clotty11208263clotty
deity94316773deit_y
ditsy95612563_ditsy
ditty95019293_ditty
ditz146929523_ditz_
dizzy177410853_dizzy
elite56230183elit_e
elites66027123elites
filthy15356423filthy
fitly115114973_fitly
fizzy199015083_fizzy
flatly123110213flatly
flimsy14345563flimsy
flinty126112493flinty
flippy1654613flippy
flirty12499143flirty
flit76539273flit__
flitch14928173flitch
flite85424963flit_e
flited104616583flited
flites95122443flites
flits85625223flit_s
floozy21356613floozy
flutey125212523flutey
fluty114415643flut_y
fritz176020773fritz_
frizzy20555833frizzy
gaiety10119373gaiety
gaily95020973gai_ly
gainly1049323gainly
gait56150193gait__
gaited84416923gaited
gaiter73819503gaiter
gaits65726013gait_s
gantry103810113gantry
gauzy18489213g_auzy
gelidly1234753gelidly
gently103710913gently
gentry103410443gentry
giddy115810213g_iddy
gilly94321633g_illy
gilt56348553gilt__
gilts64924263gilt_s
gimpy135212233g_impy
ginny95314573g_inny
ginzo1539613g_inzo
gipsy11579543g_ipsy
girly94415293g_irly
git46266063g_it__
gite55438623g_it_e
gites65630183g_ites
gits55744603g_it_s
gladly11497933gladly
glady105413943gl_ady
glairy10448273glairy
glary96018543gl_ary
glassy10527753glassy
glaze155418163gl_aze
gleamy12398113gleamy
gleety10479193gleety
glegly1134873glegly
gley85724653gl__ey
glia56423153gli__a
glial66715433gli_al
glias64618493gli_as
glib79421443gli__b
glide74521603gli_de
glided94513903glided
glider84614263glider
glides84518863glides
gliff124915663gli_ff
gliffs13436323gliffs
glim76026353gli__m
glime85620193gli_me
glimed105312283glimed
glimes94717523glimes
glims87417673gli_ms
glint66830183gli_nt
glinted9399373glinted
glints75714213glints
glioma935953glioma
glisten8418083glisten
glister84013343glister
glitter84211803glitter
glittery12375613glittery
glitzier1833593glitzier
glitzing1934973glitzing
globby1434683globby
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293gl_ory
glossy10549003glossy
gloze154815983gl_oze
gluey95715263gl_uey
gluily10308293gluily
glumly12356623glumly
glumpy14527193glumpy
glut56331293glut__
glute66020903glut_e
glutei7409743glutei
gluten74210753gluten
glutes74517673glutes
gluts66120133glut_s
gnatty10336483gnatty
goiter74116203goiter
goitre7349003goitre
gouty95217363gout_y
grimly12459933grimly
grimy114312603gri_my
gripey124111203gripey
grippy14447763grippy
gripy115115253gri_py
grisly104310583grisly
gristly11187333gristly
grit55247243grit__
grith95520373grit_h
griths105211653griths
grits65529583grit_s
grizzly19354473grizzly
groszy19395703groszy
grotty10389833grotty
guilty10418233guilty
guitar7117443guitar
gusty95119573gust_y
gutsy96412843g_utsy
gutty94516993g_utty
kilty125213903kilt_y
kitty124614573_kitty
klutz1868853klutz_
laity85318903lait_y
lathy115215063_lathy
lazy166423073_l_azy
lezzy16608083_lezzy
lily76730193_li_ly
limby125714073_limby
limey104721043_limey
limy95727723_li_my
lindy96918323_lindy
liney87029633_liney
lingy96925143_lingy
linky127622383_linky
linty87126563_linty
liny78141333_li_ny
lippy124511903_lippy
lit39377323_lit__
litai55216363_litai
litany939053_litany
litas54923773_litas
lite47054553_lit_e
liter54736343_liter
lithe84922013_lithe
litho86513783_litho
litre55421463_litre
lits46252503_lit_s
litu47631573_lit_u
lutz136826323_lutz_
milty104720073milt_y
mity95528223_mit_y
nitty85418313_nitty
pithy135614463_pithy
pity96031943_pit_y
platy105021663plat_y
plisky1533713plisky
plotty11208853plotty
plotz164617003plotz_
polity113015863polit_y
ritz135129993_ritz_
shitty124110063shitty
silty84721633silt_y
sizy164816403_si_zy
slatey95417063slatey
slaty86523153slat_y
sleazy18267393sleazy
slily85820033sli_ly
slimly11408903slimly
slimsy11407723slimsy
slimy105417423sli_my
slinky13399103slinky
slippy1375843slippy
slit46250103slit__
slits56128853slit_s
slutty9248003slutty
smithy14508273smithy
spitz166017973spitz_
stithy12398213stithy
titty85316653_titty
tizzy16548893_tizzy
uglify1333913ugli_fy
uglily1036193ugli_ly
unity84918493unit_y
whitey154911883whitey
whity145513473whit_y
whizzy23274073whizzy
withy144813763_withy
witty114717013_witty
zloty17399793zlot_y

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162355.61020092.0
3Display Results2352350.0603916.7
 (SQL Overall)1786912356.07629409.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.