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

240 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
glitzing193497(None) 
blitzing2035901blitzing
fliting113514612flit_ing
flitting123010882flitting
gaiting93716582gait_ing
gitting93215702g_itting
glazing183611002gl_azing
gliding103911842gli_ding
gliming113310132gli_ming
glinting103210052glinting
glitzier1833592glitzier
glozing18338892gl_ozing
glutting10247642glutting
gritting10309982gritting
plotzing20276152plotzing
slitting93012582slitting
agatizing2087473agatizing
agnizing1936833agni_zing
aliasing9310073aliasing
alibiing1135323alibiing
aliening91510903aliening
aligning10158533aligning
alining81917043ali_ning
baiting103918883bait_ing
biting95321823_bit_ing
bitting103717293_bitting
blatting114111653blatting
blazing193612393bl_azing
blinding123210163blinding
blinking153510623blinking
blipping15306803blipping
blissing1136873blissing
blotting113910433blotting
chitling142910663chitling
citing94220183_cit_ing
clicking173610983clicking
climbing15205983climbing
clinging122910913clinging
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
clothing14278783clothing
clotting113110643clotting
editing9313133edit_ing
elating83423083elat_ing
eliding93414343eli_ding
eluting84115293elut_ing
emitting112410353emitting
eviting11511373evit_ing
exiting15311393exit_ing
faithing1537153faithing
fitting113516563_fitting
fizzing19276403_fizzing
flatling123410013flatling
flatting123511253flatting
flicking184110043flicking
flinging133310053flinging
flinting123412343flinting
flipping16307663flipping
flirting12319013flirting
flitching18265343flitching
fluting113815093flut_ing
flyting14378553flyt_ing
fritting123510703fritting
frizing203310873fri_zing
frizzing2064803frizzing
futzing20307903_futzing
gaining94015663gai_ning
gasting95022763gast_ing
gating84826953g_at_ing
gazing174717173g__azing
gelating103015733gelat_ing
gentling1048453gentling
getting93316563g_etting
gibbing13339373g_ibbing
gibing103712353g_i_bing
gieing83614853g_i_eing
gifting123810893g_ifting
gigging93311773g_igging
gilding103813003g_ilding
gilling93520383g_illing
gillying13306813gillying
gimping133710763g_imping
ginning93313983g_inning
gipping133813123g_ipping
girding103611883g_irding
girning93210693g_irning
girthing13256083girthing
girting93113333g_irting
gittin72910553g_ittin_
giving114313883g_i_ving
glaceing1236533glaceing
gladding1236303gladding
glairing1047283glairing
glancing1247063glancing
glaring93714883gl_aring
glassing10329973glassing
glazings19325753gl_azings
gleaming12277933gleaming
gleaning10269323gleaning
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gl_eying
gliadin935593gliadin_
gliadine1045403gliadine
gliadins1035193gliadins
glimpsing1542593glimpsing
glistening1294283glistening
glistering12106423glistering
glittering1296003glittering
glitz154916373glitz___
glitzed18375493glitz_ed
glitzes17367563glitz_es
glitziest1944003glitziest
glitzy19404783glitz__y
gloaming12268013gloaming
gloating102611463gloating
globing113210003gl_obing
glomming14275923glomming
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glouting10379693glouting
gloving12308443gl_oving
glowing123211793gl_owing
glueing9338713gl_ueing
glugging10316353glugging
gluing83812053gl__uing
grating93923183grat_ing
grazing183514553g_razing
griding103014973gri_ding
grieving1385893grieving
grifting13299263grifting
grilling103811533grilling
griming113612493gri_ming
grinding1139863grinding
grinning1037863grinning
griping113012063gri_ping
gripping14277543gripping
grizzling1942843grizzling
guiding102911843gui_ding
guiling93214213gui_ling
guising93511413gui_sing
gusting93917163gust_ing
gutting93415923g_utting
guttling1037293guttling
hilting113316893hilt_ing
hitting113017273_hitting
igniting1037363ignit_ing
jilting153211743jilt_ing
kibitzing2542333kibitzing
kilting123213853kilt_ing
kithing153411553_kithing
kiting114117093_kit_ing
kitling123313573_kitling
kitting123214443_kitting
knitting13257023knitting
lathing114315693_lathing
lazing164821473_l_azing
letting83218533_letting
licking144118283_licking
lidding103611433_lidding
lifting113313273_lifting
liking114319583_li_king
lilting83515383_lilting
limbing123410423_limbing
liming94021243_li_ming
limning103710323_limning
limping124614113_limping
lining74526803_li_ning
linking123818253_linking
linting83820983_linting
lipping123016073_lipping
lisping103412753_lisping
listing84020593_listing
lithoing1236743_lithoing
living104318323_li_ving
lotting82917753_lotting
luting75221753_lut_ing
milting103619123milt_ing
mitring103514143_mitring
omitting11217743omitting
pithing134014053_pithing
pitting103618873_pitting
pitying132910243_pitying
plaiting113113513plait_ing
plating103823073plat_ing
platting114813033platting
plinking153611243plinking
plotting113011013plotting
prizing193514683pri_zing
putzing19359123_putzing
quitting18228833quitting
quizzing2643403quizzing
seizing174114833sei_zing
shitting123212663shitting
silting83320483silt_ing
siting74126623_sit_ing
sitting83519633_sitting
sizing163616443_si_zing
skiting123812503skit_ing
slating83724653slat_ing
slatting94014233slatting
slicing103514643sli_cing
slicking153712593slicking
sliding93114553sli_ding
sliming102913953sli_ming
slimming13288093slimming
slinging103312863slinging
slinking133412983slinking
sliping103314413sli_ping
slipping133510663slipping
slotting92612613slotting
smiting103014443smit_ing
spiting103917623spit_ing
spitting113012323spitting
splitting1236563splitting
spritzing2135393spritzing
suiting83419003suit_ing
tilting83417103tilt_ing
tithing113513893_tithing
titling83715793_titling
toiting83217093toit_ing
trithing122811773trithing
twitting12307223twitting
uglifying1743963uglifying
uniting8315823unit_ing
unitizing1947803unitizing
waiting113618953wait_ing
waltzing2134263waltzing
whiting143311303whit_ing
whizzing2333383whizzing
wilting113515913wilt_ing
withing143814493_withing
witing103522823_wit_ing
witling113215813_witling
witting113417063_witting
writhing15278673writhing
writing113713893writ_ing

Search took 10 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.483369960.7
2DLD Change Limit1461622408.51617163.2
3Display Results2402400.0932580.6
 (SQL Overall)1786912409.09219653.7
 
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.