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

251 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
gunnings1034673(None) 
cunnings11357351cunnings
ginnings10366521ginnings
gunning93413171gunning_
runnings9326911runnings
buntings11348772buntings
burnings11387622burnings
cannings113710342cannings
cunning104214632cunning_
dunning93514472dunning_
funning113813612funning_
ginning93313982ginning_
guanines989772guanines
guanins8810012guanin_s
gunnies83413122gunni_es
huntings12328052huntings
innings8329442_innings
kennings13315272kennings
muntings11289812muntings
punning103414992punning_
running83514592running_
sunning83715672sunning_
tannings9268632tannings
tunning83514452tunning_
turnings9287232turnings
winnings12327582winnings
agentings1134443agentings
antings85015583_antings
audings9289393au_dings
awnings11406713_awnings
bankings15489403bankings
banning103818233banning_
beginnings1441703beginnings
bindings123810473bindings
binning103615453binning_
bondings12369413bondings
buddings13326653buddings
bundlings13235563bundlings
bunging113616503bunging_
bunglings13235213bunglings
bunking144016193bunking_
bunnies94415003bunni_es
bunting103718833bunting_
burning104215503burning_
bushings14348793bushings
busings103711223bu_sings
bussings11386663bussings
canning103620143canning_
churnings15233413churnings
clonings11307443clonings
conning103718773conning_
cunninger1242763cunninger
cunningest1343353cunningest
cunningly1545533cunningly
cuppings15336053cuppings
curbings13407313curbings
curlings114110383curlings
cuttings11277613cuttings
darnings10378553darnings
denning93515173denning_
dinning93416553dinning_
donning93512773donning_
dubbings14245473dubbings
ductings12346673ductings
dumpings14295763dumpings
dunging103012623dunging_
dunking133813263dunking_
dunlins849553dunlin_s
dunnites947173dunnites
dunting93418383dunting_
durning93511733durning_
dustings10419033dustings
eanlings9128473eanlings
earnings9419333earnings
endings92910443_endings
evenings1234393evenings
fanning113615073fanning_
fencings14225663fencings
findings13328443findings
finings114311773_finings
finning113615113finning_
funding124113663funding_
funking154013023funking_
funnies104113603funni_es
funniness12256533funniness
furrings12317143furrings
gaining94015663gaining_
gamings114610913g_amings
ganging103216193ganging_
gaskings14427473gaskings
gassings10438403gassings
gatings95212823g_atings
gaywings1633193gaywings
gearings10359503gearings
geldings11316163geldings
gensengs1043093gensengs
gildings11356973gildings
ginsengs1042653ginsengs
girning93210693girning_
glazings19325753glazings
gleanings11244643gleanings
gleyings13283653gleyings
gnawings13263773gnawings
godlings11367493godlings
goings84911523g__oings
golfings13304873golfings
gonging103713033gonging_
goslings10297553goslings
gowning12258843gowning_
gratings103910763gratings
grazings19337263grazings
greenings11266673greenings
grinning1037863grinning_
groundings1343743groundings
gruelings1163763gruelings
grunting10269583grunting_
guanin7610803guanin__
guanine8810543guanin_e
guenons836563guenon_s
guiding102911843guiding_
guiling93214213guiling_
guising93511413guising_
gulfing12339473gulfing_
gulling94019563gulling_
gulping11309753gulping_
gumlines11238573gumlines
gumming133810193gumming_
gundogs1034603gu_ndogs
gunfires1235063gunfires
gunflints1342773gunflints
gunites8313123gu_nites
gunnels8358563gunn_els
gunnen7338713gunnen__
gunners83111733gunn_ers
gunnybags169863gunnybags
gunpoints1243273gunpoints
gunrunnings1351113gunrunnings
gurging102910113gurging_
gushing124014223gushing_
gusting93917163gusting_
gutting93415923gutting_
guying11379723gu_ying_
guylines12236943guylines
hangings13258583hangings
hornings12238373hornings
hunting114317123hunting_
hurlings12388213hurlings
huskings16276043huskings
hustings12378683hustings
inning73617633_inning_
ironings9217583ironings
joinings16285253joinings
junking193910073junking_
kenning124010543kenning_
landings103110073landings
leanings94010183leanings
linings84313073_linings
loanings9348023loanings
longings10408563longings
lunging93714213lunging_
lunting83817743lunting_
lutings83311053lu_tings
manning103616383manning_
meanings11329163meanings
mendings12338303mendings
minings103912073_minings
mornings11297933mornings
mountings12266163mountings
mournings1243543mournings
muggings13244593muggings
munnions1035273munnions
munting103718773munting_
muntins92715133muntin_s
musings10389543mu_sings
noonings9246663noonings
nursings9325773nursings
nuttings9276783nuttings
openings1134823openings
outings84014753ou_tings
outrings92811053outrings
outsings93410333outsings
panning104019393panning_
pennines103112043pennines
penning103616493penning_
pinkings15338143pinkings
pinning103417853pinning_
plannings12325453plannings
puddings13325503puddings
pulings103511323pu_lings
punkins133111113punkin_s
punningly1545153punningly
punting103318443punting_
purgings12347293purgings
purlings113910283purlings
quininas17286033quininas
quinines172410203quinines
quinins162811293quinin_s
rankings13389173rankings
rennins74013413rennin_s
rinning83216743rinning_
rinsings9318013rinsings
rubbings13306333rubbings
ruchings14287073ruchings
ruining83514883ruining_
rulings83310383ru_lings
runniness9247103runniness
rushings12387843rushings
scannings12264823scannings
shunning12367843shunning_
sinning83918443sinning_
soundings11266153soundings
spinnings12294853spinnings
stunning9298463stunning_
subbings13238483subbings
subrings11229883subrings
suitings9288953suitings
sunniness9247943sunniness
surfings12268073surfings
tanning83618253tanning_
tannins72813223tannin_s
tinning83117283tinning_
tintings9288713tintings
tubings10336483tu_bings
tuftings12264323tuftings
tuning74016843tu_ning_
tunnelings1142493tunnelings
tunnies73614263tunni_es
turning83713183turning_
twinnings13253663twinnings
unbinds10267353_unbinds
uncinus937403_uncinus
undines8716083_undines
undoings1035793_undoings
unhangs1136203_unhangs
unhinge11237283_unhinge
unhinges12266723_unhinges
unkinks10265413_unkinks
unlinks11307403_unlinks
unpins82312383_unpin_s
unrigs7159003_unri_gs
unslings937283_unslings
unwinds11286733_unwinds
uppings12257123_uppings
vanning113912463vanning_
veinings12306433veinings
wanning113816213wanning_
warnings12358453warnings
windings13329973windings
winning113516553winning_
wonning113210803wonning_
yenning11369493yenning_

Search took 8 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.420425454.8
2DLD Change Limit1461622517.36019859.0
3Display Results2512510.1102281.8
 (SQL Overall)1786912517.89022647.8
 
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.