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

323 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
winnings1232758(None) 
ginnings10366521ginnings
innings8329441_innings
twinnings13253661twinnings
windings13329971windings
winning113516551winning_
bindings123810472bindings
binning103615452binning_
cannings113710332cannings
cunnings11357342cunnings
dinning93416552dinning_
findings13328442findings
finings114311772fi_nings
finning113615112finning_
ginning93313982ginning_
gunnings10346732gunnings
inning73617632_inning_
kennings13315272kennings
linings84313072li_nings
minings103912072mi_nings
pinkings15338142pinkings
pinning103417852pinning_
rinning83216742rinning_
rinsings9318012rinsings
runnings9326912runnings
sinning83918442sinning_
spinnings12294852spinnings
swingings14275052swingings
tannings9268632tannings
tinning83117282tinning_
tintings9288712tintings
twinning12367042twinning_
wanning113816212wanning_
warnings12358452warnings
wickings18357182wickings
wiggings14316172wiggings
wildings13287932wildings
wincing133413902wincing_
winding123517912winding_
windlings14236722windlings
wingdings1543682wingdings
winging123718712winging_
wining103625052wi_ning_
winking153317962winking_
winningly1644412winningly
wirings113910112wi_rings
witlings12328442witlings
wittings12328732wittings
wonning113210792wonning_
airings83913843ai_rings
antings85015583_antings
awnings11406713_awnings
bankings15489403bankings
banning103818233banning_
beginnings1441703beginnings
biddings13397563biddings
biggings13327473biggings
billings113412633billings
binding113819383binding_
binging113619383binging_
birdings12378823birdings
birlings11359613birlings
bittings11339293bittings
bondings12369413bondings
buntings11348773buntings
burnings11387623burnings
canning103620133canning_
chinning14329653chinning_
clonings11307433clonings
conning103718753conning_
cunning104214623cunning_
darnings10378553darnings
denning93515173denning_
dialings10329823dialings
diggings12316623diggings
dinging103618613dinging_
dining84525133di_ning_
dinking133618283dinking_
dinting93520553dinting_
donning93512763donning_
drinkings15244773drinkings
dunning93514473dunning_
dwining12269293dwi_ning_
eanlings9128473eanlings
earnings9419333earnings
endings92910443_endings
evenings1234383evenings
fanning113615073fanning_
fencings14225663fencings
filings115213073fi_lings
fillings122910503fillings
financings1641853financings
finding124116543finding_
fining104223213fi_ning_
finking154016603finking_
firings114112333fi_rings
fishings15307693fishings
fittings12318203fittings
fixings18347443fi_xings
funning113813613funning_
gildings11356973gildings
ginsengs1042653ginsengs
girning93210693girning_
grinning1037863grinning_
gunning93413173gunning_
hangings13258583hangings
hidings12349703hi_dings
hildings13347503hildings
hinging123917123hinging_
hinnies103615103hinni_es
hinnying15124853hinnying_
hinting113919223hinting_
hissings12556753hissings
hornings12238363hornings
huntings12328053huntings
icings9428453_i_cings
impings12348553_impings
inbeings1134603_inbeings
inking115119053_inking_
inklings13246383_inklings
intines7921113_intines
inwinds11216273_inwinds
ironings9217583ironings
jinking193613543jinking_
jinnis13489053jinni__s
jinxing22306503jinxing_
joinings16285243joinings
kenning124010543kenning_
killings133710483killings
kilning12289023kilning_
kiltings13327083kiltings
kindlings15195273kindlings
kinging133115033kinging_
kinins104014583ki_nin_s
kinking113615153kinking_
kirning12319333kirning_
kitlings13318103kitlings
landings103110073landings
leanings94010183leanings
lickings15298143lickings
lignins84010493lignin_s
likings12539413li_kings
limning103710323limning_
lining74526803li_ning_
linins65922143li_nin_s
linking123818253linking_
linsangs944413linsangs
linting83820983linting_
lippings13296093lippings
listings93310043listings
livings11408923li_vings
loanings9348013loanings
longings10408563longings
manning103616383manning_
meanings11329163meanings
mendings12338303mendings
millings113712583millings
mincing123314333mincing_
minding113317893minding_
mining94225453mi_ning_
minnies93617363minni_es
minting103020813minting_
mornings11297923mornings
muntings11289813muntings
ninnies73713613ninni_es
noonings9246653noonings
oinking123714713oinking_
openings1134803openings
paintings12327093paintings
panning104019393panning_
pennines103112043pennines
penning103616493penning_
pickings17359383pickings
piecings1345343piecings
pilings103313613pi_lings
pinangs10267793pi_nangs
pinging113419553pinging_
pining93726533pi_ning_
pinking143918943pinking_
pinnies93318443pinni_es
pipings12338253pi_pings
pittings11349123pittings
plannings12325453plannings
printings12268103printings
punning103414993punning_
rankings13389173rankings
rennins74013413rennin_s
rewinning13257443rewinning_
ribbings13275923ribbings
ridings93412093ri_dings
riflings12227303riflings
riggings11327133riggings
ringing93521283ringing_
rinsing82516113rinsing_
risings83211893ri_sings
running83514593running_
scannings12264823scannings
shinning123211023shinning_
siblings11108123siblings
sidings94011463si_dings
siftings12236583siftings
signing92713963signing_
singing93221423singing_
sinking123320543sinking_
sittings9339733sittings
sizings17378013si_zings
skinning13327893skinning_
spinning113310813spinning_
sunning83715673sunning_
swanning12338813swanning_
swimmings17263153swimmings
swinging133411113swinging_
swinking163410323swinking_
tanning83618253tanning_
tannins72813223tannin_s
thinkings17255053thinkings
thinning12319093thinning_
tickings15368583tickings
tidings93810263ti_dings
tilings84212793ti_lings
timings10279303ti_mings
tinging93619463tinging_
tining74927543ti_ning_
tinklings14224663tinklings
tinniness936093tinniness
tinnitus843783tinnitus
tinting84620603tinting_
tithings12327693tithings
tunning83514453tunning_
turnings9287233turnings
twillings13234913twillings
twinging13278423twinging_
twining113211443twi_ning_
twinklings1841883twinklings
twistings13264353twistings
vanning113912463vanning_
veinings12306433veinings
viewings1533983viewings
vikings15386623vi_kings
vining104619463vi_ning_
waddings14356473waddings
waistings1352710763waistings
waitings123413743waitings
wakenings1743043wakenings
walkings16327313walkings
waning103623803w_aning_
wanking154216783wanking_
wanting114220173wanting_
warning113717093warning_
washings15419273washings
waxings18366453w_axings
waxwings2232953waxwings
weaning114117193weaning_
weanlings1394413weanlings
webbings1633243webbings
weddings14355533weddings
weening114113973weening_
weepings14346483weepings
weltings12388203weltings
wending123816843wending_
westings12429803westings
wettings12348403wettings
whalings15256763whalings
whingdings1941813whingdings
whinging16247743whinging_
whining143311673whining_
whinnies14237273whinni_es
whinnying19172733whinnying_
whippings20284183whippings
whitenings1742613whitenings
whitings15287063whitings
wicking173414773wicking_
widening13237833widening_
wienies102213683wieni_es
wifing133513393wi_fing_
wigging133413833wigging_
wilding123814293wilding_
wildlings14244923wildlings
wiling103024293wi_ling_
willing113821613willing_
wilting113515913wilting_
wimping153911013wimping_
winching17359903winching_
windbags1544523windbags
windigo12415953windi_go
windigos13484903windigos
windiness1337373windiness
windingly1745323windingly
windling132212263windling_
wingding1436453wingding_
wings95727243w___ings
winkingly2044343winkingly
winkling16298293winkling_
winners104316913winn_ers
winnocks1743873winnocks
winnowing1643363winnowing_
winnows1334533winn_ows
wintling12249923wintling_
wiping123916713wi_ping_
wiring104521023wi_ring_
wishing144114893wishing_
wising103318223wi_sing_
wisping133711943wisping_
wissing113212943wissing_
wisting113519743wisting_
witchings18325303witchings
withing143814493withing_
withins133511693within_s
witing103522823wi_ting_
witling113215813witling_
witting113417063witting_
wiving133316603wi_ving_
wizening21255463wizening_
wonting113214103wonting_
wordings13328563wordings
workings16337503workings
wringing13279623wringing_
wrings104012973w__rings
writings12298113writings
yenning11369493yenning_
zincing192910283zincing_
zinging183513943zinging_
zinnias1635863zinni_as

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.406440125.6
2DLD Change Limit1461623236.87321266.1
3Display Results3233230.1402307.1
 (SQL Overall)1786913237.41924085.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.