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

227 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
shearings1333756(None) 
hearings123611851_hearings
shealings13317561shealings
shearing123915901shearing_
shearlings1443531shearlings
bearings113912252_bearings
clearings12286062clearings
earings84517712__earings
gearings10359502_gearings
headings133510492_headings
hearing113324162_hearing_
herrings12379532_herrings
rehearings14214572rehearings
searing83330922s_earing_
seatings93614302s_eatings
shadings13327432sh_adings
sharing113723242sh_aring_
shavings15356332sh_avings
sheafing15329482sheafing_
shealing123415462shealing_
shearlegs1342492shearlegs
shearling1336922shearling_
sheathings1743912sheathings
sheaving154110252sheaving_
sheering123715102sheering_
sheetings13256712sheetings
shelvings16283822shelvings
shirrings13245322shirrings
shorings12269482sh_orings
showrings1644062showrings
smearing113511752smearing_
soarings93210392s_oarings
speakings16345932speakings
spearing113216102spearing_
speerings12276842speerings
steadings11307082steadings
stealings10318852stealings
stearines9311282stearines
stearins8312142stearin_s
swearing123711442swearing_
anearing9413973anearing_
ashlaring1344493ashlaring_
beadings123711783_beadings
bearing103624773_bearing_
beatings114113233_beatings
blearing113111943blearing_
breakings16297063breakings
charing133721323ch_aring_
chasings14318253ch_asings
cheating144014523cheating_
cheering143612703cheering_
clearing113014883clearing_
clearwings1651703clearwings
darings93713653__darings
dealings103510703_dealings
earing75235483__earing_
earnings9419333__earnings
earrings9299633__earrings
eatings84616443__eatings
fearing113520033_fearing_
gearing92818843_gearing_
gleanings11244643gleanings
haring104233003_h_aring_
harpings14379773_h_arpings
hayings14379393_h_ayings
hazings20378343_h_azings
heading122919113_heading_
healing113922963_healing_
heaping133015853_heaping_
hearsing1239383_hearsing_
hearting12513123_hearting_
heating114024323_heating_
heaving144114763_heaving_
heelings12359753_heelings
heiring113312903_heiring_
helpings14255653_helpings
heparins13310123_heparin_s
herring113615883_herring_
hoardings14315113_hoardings
leadings103511243_leadings
leanings94010183_leanings
learnings1094323_learnings
leasings9379843_leasings
leavings12407493_leavings
meanings11329163_meanings
mishearing1647883mishearing_
nearing83020333_nearing_
parings104219213__parings
pharmings17254723ph_armings
phrasings1544333phrasings
phreakings2043193phreakings
pleadings13285543pleadings
readings103512643_readings
rearing83128783_rearing_
rehearing132211763rehearing_
roarings9248293_roarings
sacrings11278923s_acrings
sarins63932623s__arin_s
sarongs84511803s__arongs
savarins1139893savarin_s
savings114412953s__avings
sayings113610833s__ayings
scaring103421973s_caring_
schmearing1842863schmearing_
scourings12235293scourings
scrapings14255173scrapings
seafarings1442783seafarings
sealing83528563s_ealing_
seaming103222113s_eaming_
searingly1338273s_earingly
seating84130683s_eating_
seedlings11195953seedlings
seeings84411293s_e_eings
seemings11337643s_eemings
seisings9398523s_eisings
seizings18326473s_eizings
sergings10299213s_ergings
serines74229543s_e_rines
sering74731813s_e_ring_
seringa83310743s_e_ringa
seringas9339003s_e_ringas
serins64029673s_e_rin_s
servings12249223s_ervings
settings93810073s_ettings
sewings11369173s_e_wings
shading123115563sh_ading_
shaftings16224183shaftings
shairns10276783sh_airn_s
shaking153317253sh_aking_
shaming133016743sh_aming_
shaping133116183sh_aping_
shariahs14206393sh_ariahs
sharias102516003sh_ari_as
sharifs13279903sh_ari_fs
sharking163912973sh_arking_
sharns95516983sh_ar_n_s
sharping143011373sh_arping_
shaving143414333sh_aving_
shawing143514883sh_awing_
shearers113911323shear_ers
shears93820903shear___s
sheathing1636873sheathing_
shebangs1443593she_bangs
shedding14278113shedding_
sheening123010803sheening_
sheerlegs1343293sheerlegs
sheeting122712833sheeting_
shelling123515213shelling_
shelving15278173shelving_
shending132511253shending_
sheriffs17253923she_riffs
sherifs13299683she_ri_fs
sherries111812903sherri_es
sherris10168803sherri__s
sherrises12156873sherrises
shewing143812193she_wing_
shielings13237123shielings
shillings13348093shillings
shippings17275683shippings
shirring122910443shirring_
shirtings13276603shirtings
shoaling123111753shoaling_
shoestrings1542643shoestrings
shootings13266063shootings
shoppings17295073shoppings
shoring112820073sh_oring_
showings15246883sh_owings
showring1548323showring_
shrines104618693sh__rines
shrinks14397913sh__rinks
shuckings19273853shuckings
skatings13326993s_katings
skiorings14243793skiorings
slatings94011723s_latings
sleaving123310983sleaving_
sleddings12263783sleddings
sleepings12335883sleepings
snaring83920953s_naring_
sneaking133211093sneaking_
sneaping11349493sneaping_
sneering93414503sneering_
soaring83521893s_oaring_
sorings83817253s__orings
spacings13287043s_pacings
spaeings11276253s_paeings
sparing104823873s_paring_
sparlings12257153s_parlings
speaking153212493speaking_
speaning113512243speaning_
spearmints1443003spearmints
speedings13265403speedings
speering113116323speering_
speiring113711263speiring_
spellings12296553spellings
sphering142811943sphe_ring_
springs104415923s__prings
squaring18158633squaring_
stagings10378343s_tagings
staring84527053s_taring_
starlings10237923s_tarlings
steading103613593steading_
stealing93416603stealing_
steaming114013213steaming_
stearin7312003stearin__
stearine8311903stearin_e
steering93916793steering_
steevings13284443steevings
sterlings10308753sterlings
stirrings10224693stirrings
streakings15235303streakings
streamings13185163streamings
strings84617133s__trings
subheadings1852053subheadings
subrings11229883s_ubrings
sugaring1039053sugaring_
sweating123213023sweating_
sweepings15345633sweepings
sweetings13326183sweetings
swellings13296103swellings
tearing84021493_tearing_
ushering1258923ushe_ring_
wearing113318863_wearing_
whalings15256763wh_alings
wheelings16284943wheelings
yealings12257703_yealings
yearlings1384203_yearlings
yearnings1393553_yearnings

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.423422437.4
2DLD Change Limit1486412276.85621680.4
3Display Results2272270.0962364.6
 (SQL Overall)1786912277.37524229.3
 
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.