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 “sharer” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

207 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
sharer9502548(None) 
scarer84524611scarer
searer65432021searer
shader104218761shader
shaker134319461shaker
shaper114119931shaper
share86437081share_
shared105829061shared
sharers104720621sharers
shares95236411shares
sharker144313811sharker
sharper124312701sharper
shaver123718911shaver
shearer104414691shearer
snarer64620841snarer
soarer64522241soarer
sparer84524961sparer
starer64027361starer
barer74535802_barer
bearer85323912bearer
carer74942332_carer
chafer144714572chafer
chare105231982chare_
chared125423692chared
chares115631802chares
charger133914062charger
charier124317902charier
charmer144913662charmer
charr104821782char_r
charter123918302charter
chaser114918382chaser
chawer144314412chawer
darer65230792_darer
dearer74822802dearer
farer86733142_farer
fearer94820182fearer
haler85033522_haler
harder105022402_harder
hare76255732_hare_
hared95742182_hared
harem104924452_harem
hares86255542_hares
harmer114719552_harmer
harper115018402_harper
hater85034752_hater
haver115124462_haver
hayer114620242_hayer
hazer174820232_hazer
hearer94323652hearer
hirer85423122_hirer
nearer64618892nearer
parer75839902_parer
rarer54731702_rarer
rearer64928912rearer
roarer63914332roarer
saber75330242s_aber
safer84721812s_afer
sager65432052s_ager
saker95132022s_aker
saner54334322s_aner
saree55044662s_aree
saver84831252s_aver
sawer85026212s_awer
sayer84926552s_ayer
scaler84321602scaler
scarcer113911372scarcer
scare75334462scare_
scared95227292scared
scarers94618512scarers
scares85033002scares
scarey115016982scarey
scarfer124511082scarfer
scarier94017872scarier
scarper114814822scarper
scorer84818262scorer
sealer63928962sealer
seamer84223612seamer
seared75232842seared
seater64534162seater
serer55935512s_erer
shade95125582shade_
shaded114518872shaded
shaders115915552shaders
shades105924532shades
shadier113111152shadier
shake124726402shake_
shaken134113612shaken
shakers144015562shakers
shakes135024592shakes
shakier143411152shakier
shale85332832shale_
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shalier103116422shalier
shame105726702shame_
shamed125120212shamed
shames114726222shames
shammer144613142shammer
shape105125112shape_
shaped125020102shaped
shapen114414652shapen
shapers124016892shapers
shapes115124952shapes
shard96125962shar_d
shards104319172shards
sharia93116732sharia
sharif122917122sharif
shark126225022shar_k
sharked153613912sharked
sharkers154011052sharkers
sharks135019722sharks
sharn84823702shar_n
sharns95516982sharns
sharny124711832sharny
sharp104922532shar_p
sharped134112052sharped
sharpen12389722sharpen
sharpers133810942sharpers
sharps115516082sharps
sharpy145211032sharpy
shatter103615702shatter
shave114425892shave_
shaved135118382shaved
shaven124213302shaven
shavers134115092shavers
shaves125224932shaves
shawed134817232shawed
sheared114516012sheared
shearers113911322shearers
sheer84726892sh_eer
sheerer103813852sheerer
shewer124515112shewer
shier85428942sh_ier
shiner93820872shiner
shire84727132shire_
shires95225572shires
shirker143711342shirker
shirr84716922shir_r
shiver124517372shiver
shoaler102610082shoaler
shoer84722162sh_oer
shore85432652shore_
shored105723652shored
shores94830412shores
shorter103515502shorter
shover124515992shover
shower124315112shower
shred98125612sh_red
shrew119720172sh_rew
shyer114714782sh_yer
skater105015492skater
slaker104219272slaker
slater64429182slater
slaver94419612slaver
slayer93916332slayer
smarter94113132smarter
smearer94110402smearer
snare54429982snare_
snared74824552snared
snarers74216662snarers
snares65329032snares
snarler73610632snarler
snorer64316762snorer
soaker105717532soaker
soaper84517872soaper
soared74324292soared
soarers74118092soarers
sorer56236592s_orer
sourer63620212sourer
spacer104917792spacer
spader94317132spader
spare75135562spare_
spared95427492spared
sparers94519612sparers
spares84834552spares
sparger103613082sparger
sparker133914362sparker
sparser94311482sparser
spearer93913662spearer
squarer163410662squarer
stager74821342stager
staler64025822staler
stare54440262stare_
stared75429872stared
starers74522312starers
stares66038752stares
starker114114692starker
starter73817882starter
starver104611992starver
stater64427562stater
stayer94516482stayer
storer64721672storer
suaver93014232suaver
sugarer837322sugarer
surer54833102s_urer
swager104013612swager
sware85828212sware_
swarmer1247802swarmer
swayer125210972swayer
swearer10349952swearer
tearer64822902tearer
thaler94613102thaler
thawer12489342thawer
wearer94319412wearer
whaler124611972whaler
yarer84321572_yarer

Search took 10 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 Filter178691825510.686260482.5
2DLD Change Limit825512078.7669417.2
3Display Results2072070.1261642.9
 (SQL Overall)1786912079.57818656.4
 
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.