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

185 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
speakings1634593(None) 
speaking153212491speaking_
breakings16297062breakings
peaking144317692_peaking_
seatings93614302s_eatings
shealings13317562shealings
shearings13337562shearings
sneaking133211092sneaking_
spacings13287042sp_acings
spaeings11276252sp_aeings
spankings16215002spankings
speaning113512242speaning_
spearing113216102spearing_
specking17359732specking_
speedings13265402speedings
speerings12276842speerings
spellings12296552spellings
steadings11307082steadings
stealings10318852stealings
streakings15235302streakings
bakings144312023__bakings
beadings123711783_beadings
bearings113912253_bearings
beatings114113233_beatings
bespeaking1944393bespeaking_
breaking153914253breaking_
clearings12286063clearings
creaking153414123creaking_
dealings103510703_dealings
deckings16346683_deckings
earings84517713__earings
eatings84616443__eatings
freaking163611453freaking_
gearings10359503_gearings
gleanings11244643gleanings
headings133510493_headings
hearings123611853_hearings
kayakings1642683kayakings
lakings124713513__lakings
leadings103511243_leadings
leaking123616973_leaking_
leanings94010183_leanings
leasings9379843_leasings
leavings12407493_leavings
makings145413163__makings
mapmakings2142453mapmakings
meanings11329163_meanings
neckings15346113_neckings
openings1134813ope_nings
packings174310063_packings
pagings114411063_p_agings
palings103915823_p_alings
parings104219223_p_arings
parkings153610693_parkings
pavings134011633_p_avings
peacing124117073_peacing_
pealing104123203_pealing_
pecking164017783_pecking_
peeking144414953_peeking_
peelings11339523_peelings
pekins121812233_pe_kin_s
perking143716463_perking_
pettings11349703_pettings
phreakings2043193phreakings
pickings17359383_pickings
pinkings15338143_pinkings
plankings16326113_plankings
platings113611363_platings
pleadings13285543pleadings
readings103512643_readings
respeaking1736803respeaking_
sackings15389633s_ackings
savings114412953s__avings
sayings113610833s__ayings
scrapings14255173scrapings
screaking16228243screaking_
sealing83528563s_ealing_
seaming103222113s_eaming_
searing83330923s_earing_
seating84130683s_eating_
seedlings11195953seedlings
seeings84411293s_e_eings
seeking124016063s_eeking_
seemings11337643s_eemings
seisings9398523s_eisings
seizings18326473s_eizings
sergings10299213s_ergings
servings12249223s_ervings
settings93810073s_ettings
sewings11369173s_e_wings
shadings13327433s_hadings
shaking153317253s_haking_
shavings15356333s_havings
sheafing15329483sheafing_
shealing123415463shealing_
shearing123915903shearing_
shearlings1443533shearlings
sheathings1743913sheathings
sheaving154110253sheaving_
sheetings13256713sheetings
shelvings16283823shelvings
shuckings19273853shuckings
skatings13326993s_katings
slaking123717473s_laking_
slatings94011723s_latings
sleaving123310983sleaving_
sleddings12263783sleddings
sleeking133410963sleeking_
sleepings12335883sleepings
smearing113511753smearing_
smeeking15317833smeeking_
smerking15258473smerking_
smockings18264283smockings
snaking123915303s_naking_
sneakiness1454873sneakiness
sneakingly1843823sneakingly
sneaping11349493sneaping_
soaking123116613s_oaking_
soarings93210393s_oarings
spacing123614493sp_acing_
spading113114383sp_ading_
spaeing103413543sp_aeing_
spanking153911973spanking_
sparing104823873sp_aring_
sparking152812543sparking_
sparlings12257153sparlings
spavins12419323sp_avin_s
spaying133014623sp_aying_
speakers14299453speak_ers
speaks125114583speak___s
speans85417143spea__n_s
spearmints1443003spearmints
speccing15306643speccing_
speckling18235583speckling_
speeding122810933speeding_
speeling112713123speeling_
speering113116323speering_
speiling113612973speiling_
speiring113711263speiring_
spelling113315233spelling_
spelunkings18131113spelunkings
spending122712433spending_
spermines13310543spermines
spewing133110453spe_wing_
spiking144312883sp_iking_
spilings11308813sp_ilings
spinnings12294853spinnings
splaying14219303splaying_
spoking143212223sp_oking_
spooking15269803spooking_
spoolings12245393spoolings
spoutings12245153spoutings
sprains93013593spra_in_s
sprangs104610053spra__ngs
spraying14299883spraying_
spreading1339653spreading_
springs104415923sp__rings
spunking15258063spunking_
squeaking2334213squeaking_
stagings10378343s_tagings
staking123919803s_taking_
stalkings14314983stalkings
steading103613593steading_
stealing93416603stealing_
steaming114013213steaming_
stearines9311283stearines
stearins8312143stearin_s
steeking133411353steeking_
steevings13284443steevings
sterlings10308753sterlings
stockings16296093stockings
streaking142010323streaking_
streamings13185163streamings
swearing123711443swearing_
sweating123213023sweating_
sweepings15345633sweepings
sweetings13326183sweetings
swellings13296103swellings
takings124512573__takings
tweaking1635883tweaking_
unspeaking1744423unspeaking_
weaklings1794003_weaklings
wreaking163010213wreaking_
wreckings19233683wreckings
yealings12257703_yealings

Search took 9 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.453394461.4
2DLD Change Limit1486411857.64019455.6
3Display Results1851850.0802312.5
 (SQL Overall)1786911858.17321863.6
 
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.