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

157 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
spinnings1229485(None) 
spinning113310811spinning_
ginnings10366522_ginnings
innings8329442__innings
pinkings15338142_pinkings
pinning103417852_pinning_
scannings12264822scannings
shinning123211022shinning_
sinning83918442s_inning_
skinning13327892skinning_
spankings16215002spankings
spanning113311082spanning_
spilings11308812spi_lings
spinnies103210542spinni_es
springings1444662springings
swingings14275052swingings
twinnings13253662twinnings
winnings12327582_winnings
beginnings1441703beginnings
bindings123810473_bindings
binning103615453_binning_
cannings113710333_cannings
chinning14329653chinning_
cunnings11357343_cunnings
dinning93416553_dinning_
drinkings15244773drinkings
findings13328443_findings
finings114311773_fi_nings
finning113615113_finning_
ginning93313983_ginning_
grinning1037863grinning_
gunnings10346733_gunnings
inning73617633__inning_
joinings16285243joi_nings
kennings13315273_kennings
linings84313073_li_nings
minings103912073_mi_nings
openings1134803op_enings
opining10311743opi_ning_
paintings12327093paintings
panning104019393_panning_
pennines103112043_pennines
penning103616493_penning_
pickings17359383_pickings
piecings1345343_piecings
pilings103313613_pi_lings
pinangs10267793_pi_nangs
pinging113419553_pinging_
pining93726533_pi_ning_
pinking143918943_pinking_
pinnies93318443_pinni_es
pipings12338253_pi_pings
pittings11349123_pittings
plannings12325453plannings
printings12268103printings
punning103414993_punning_
repinning12258973repinning_
rinning83216743_rinning_
rinsings9318013_rinsings
runnings9326913_runnings
sailings93513253sai_lings
saining83621393sai_ning_
sainting93215733sainting_
scanning113310773scanning_
seining84020773sei_ning_
seisings9398523sei_sings
seizings18326473sei_zings
shielings13237123shielings
shillings13348093shillings
shindigs13284203shindi_gs
shining113816523shi_ning_
shinnies113010913shinni_es
shinnying16193723shinnying_
shippings17275683shippings
shirrings13245323shirrings
shirtings13276603shirtings
shunning12367843shunning_
siblings11108123s_iblings
sidings94011463s_i_dings
siftings12236583s_iftings
signing92713963s_igning_
singing93221423s_inging_
sinking123320543s_inking_
sittings9339733s_ittings
sizings17378013s_i_zings
skiings12295733ski__ings
skillings14246133skillings
skimmings18243263skimmings
skinking12299773skinking_
skinniness1443313skinniness
skiorings14243793skiorings
skirtings14274563skirtings
slinging103312863slinging_
slinking133412983slinking_
soundings11266153soundings
spacings13287043sp_acings
spaeings11276253sp_aeings
spanking153911973spanking_
sparlings12257153sparlings
spawning14296913spawning_
speakings16345933speakings
speaning113512243speaning_
speedings13265403speedings
speerings12276843speerings
spellings12296553spellings
spending122712433spending_
spicing123914533spi_cing_
spieling113212523spieling_
spiering112713353spiering_
spiffing17237083spiffing_
spiking144312883spi_king_
spiling102919703spi_ling_
spilling113113943spilling_
spindling13136273spindling_
spininess1137963spininess
spinners103810863spinn_ers
spinneys13335553spinn_eys
spiring103918183spi_ring_
spirting112913633spirting_
spiting103917623spi_ting_
spitting113012323spitting_
splining11310773splining_
splinting1238193splinting_
sponging1238823sponging_
spongins1136563spongin_s
spoolings12245393spoolings
spooning112811443spooning_
spoutings12245153spoutings
springing1338743springing_
springs104415923sp__rings
sprinklings1841853sprinklings
sprinting12310033sprinting_
spunking15258063spunking_
spurning11258663spurning_
standings11257153standings
stinging103213453stinging_
stinking133113543stinking_
stinting93415743stinting_
stirrings10224693stirrings
stringings1245233stringings
stunning9298463stunning_
suitings9288953sui_tings
sunning83715673s_unning_
swanning12338813swanning_
swimmings17263153swimmings
swinging133411113swinging_
swinking163410323swinking_
tannings9268633_tannings
thinkings17255053thinkings
thinning12319093thinning_
tinning83117283_tinning_
tintings9288713_tintings
twinning12367043twinning_
unpinning1245623unpinning_
veinings12306433vei_nings
windings13329973_windings
winning113516553_winning_

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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411576.95621368.7
3Display Results1571570.0602616.7
 (SQL Overall)1786911577.16924925.5
 
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.