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

249 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
pshawed1610303(None) 
shawed134817231_shawed
ashamed1336242ashamed
chawed155214602_chawed
hawed126025422__hawed
pawed115725612p__awed
phased124011972p_hased
pshaw13447512pshaw__
pshaws14435702pshaw_s
sawed95628402_s_awed
shaded114518872_shaded
shaled105023952_shaled
shamed125120212_shamed
shaped125020102_shaped
shared105829062_shared
shaved135118382_shaved
shawled1437772_shawled
shewed134716182_shewed
showed135016962_showed
snawed104813732_snawed
thawed13458462_thawed
ascared10399523ascared
ashed97829773ash__ed
ashlared1253933ashlared
assayed1135593assayed
awed88436033___awed
behaved16176683behaved
beshamed1635733beshamed
blawed124713893_blawed
cawed116627063__cawed
chafed154813913_chafed
chared125423693_chared
chased125019293_chased
chawer144314413_chawer
chewed154415013_chewed
chowed154914643_chowed
clawed125115073_clawed
dawed106222813__dawed
escaped12388853escaped
eschewed1743443eschewed
essayed1134013essayed
estated83715573estated
exhaled1835283exhaled
flawed134712723_flawed
gnawed11427833_gnawed
haded105227623__haded
haed86338583__ha_ed
haled95335823__haled
hared95742183__hared
hated95734023__hated
hawked174712673__hawked
hayed125822013__hayed
hazed185222203__hazed
heehawed1842733heehawed
hewed125619433__hewed
inhaled1169333inhaled
jawed165517373__jawed
lawed96028323__lawed
mawed115824743__mawed
paced106931683p__aced
paged95926783p__aged
palaced124110773palaced
paled85538723p__aled
paned85437183p__aned
paraded114014263paraded
pared86946763p__ared
pashed125923143pash__ed
passaged1236243passaged
pated85237843p__ated
paved115525263p__aved
pawer104422973p__awer
pawned124513283p__awned
payed115925933p__ayed
peaced115818913p_eaced
peaked136117403p_eaked
pealed95322803p_ealed
pedaled113711883pedaled
petaled103614143petaled
phage115113673p_hage_
phages125213513p_hages
phase104617213p_hase_
phases114618403p_hases
phoned124014553p_honed
phrased1387383phrased
physed15386793p_hysed
pirated102515613pirated
pished124817063pish__ed
placed114318003p_laced
planed94420913p_laned
plated95225773p_lated
played124815033p_layed
pleaded113511263pleaded
pleased103712073pleased
pleated103816633pleated
plowed124213203p_lowed
pomaded13377863pomaded
prated94924923p_rated
prawned1346743p_rawned
prayed124815433p_rayed
preaged11612333preaged
preshaped1745523preshaped
preshowed1875183preshowed
psalmed1234503psalmed
pshawing1733523pshawing
psoae74411623psoa_e_
psyched1843913psyched
pupated12319353pupated
pushed125017463push__ed
resawed113111183resawed
reshaped1437203reshaped
reshaved1536873reshaved
reshowed15117063reshowed
ripsawed1442533rips_awed
sabed86526813_s_abed
saned65636273_s_aned
sashayed1543553sashayed
sated66238533_s_ated
saved95127113_s_aved
sawer85026213_s_awer
sayed96127143_s_ayed
scaled94822443_scaled
scaped115519553_scaped
scared95227293_scared
scowed124413823_scowed
seabed95017693_seabed
sealed74328363_sealed
seamed94823883_seamed
seared75232843_seared
seated75131053_seated
seaweed11108813_seaweed
sewed95325163_s_ewed
shacked174015393_shacked
shad86230913_sha__d
shade95125583_shade_
shader104218763_shader
shades105924533_shades
shadowed1644473_shadowed
shafted14288803_shafted
shagged134210123_shagged
shaird10288703_shaird
shake124726403_shake_
shaken134113613_shaken
shaker134319463_shaker
shakes135024593_shakes
shale85332833_shale_
shales94731253_shales
shaley123714993_shaley
shame105726703_shame_
shames114726223_shames
shammed153911423_shammed
shanked153212123_shanked
shape105125113_shape_
shapen114414653_shapen
shaper114119933_shaper
shapes115124943_shapes
shard96125963_sha_rd
share86437083_share_
sharer95025483_sharer
shares95236413_shares
sharked153613903_sharked
sharped134112043_sharped
shauled1148793_shauled
shave114425893_shave_
shaven124213303_shaven
shaver123718913_shaver
shaves125224933_shaves
shaw108132553_shaw__
shawl116217573_shaw_l
shawls125411973_shawls
shawm135316143_shaw_m
shawms14579563_shawms
shawn116417613_shaw_n
shaws116226263_shaw_s
sheafed14388973_sheafed
sheared114516003_sheared
sheaved143411633_sheaved
shed86536153_sh__ed
shewer124515103_shewer
shied96125493_sh_ied
shined104620783_shined
shoaled113810963_shoaled
shoed95723003_sh_oed
shooed103916073_shooed
shored105723643_shored
shoved134214273_shoved
shower124315103_shower
shred98125613_sh_red
shrewd136810773_shrewd
shrewed14589843_shrewed
shuted103913163_shuted
skated114414873_skated
skewed145610233_skewed
slaked114318273_slaked
slated75028313_slated
slaved104017043_slaved
slayed104716223_slayed
slewed104815523_slewed
slowed104617073_slowed
snaked115017593_snaked
snared74824553_snared
snowed104613613_snowed
soaked114717593_soaked
soaped95817973_soaped
soared74324293_soared
sowed94933863_s_owed
spaced114517253_spaced
spaded103816753_spaded
spaed85522273_spa_ed
spared95427483_spared
spawned13316803_spawned
spayed124213613_spayed
speaned103411523speaned
speared104314423speared
spewed125512333_spewed
sphered133512313sphered
splayed13357813splayed
sprawled1434513sprawled
sprayed13398903sprayed
staged84521563_staged
staked114621943_staked
staled74728103_staled
staned74824643_staned
stared75429873_stared
stated75427833_stated
staved103918053_staved
stayed104817273_stayed
stewed104814243_stewed
stowed105817203_stowed
strawed114813613strawed
swaged114212253_swaged
swayed133510263_swayed
tawed95926193__tawed
thawer12489343_thawer
thrawed1435583thrawed
unawed103914903_unawed
unsawed112911503unsawed
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unthawed1535583unthawed
upscaled13144873upscaled
upsoared11154353upsoared
upstaged12135243upstaged
upstared11156573upstared
ushered1139153ushered
whaled134612033_whaled
yawed126022453__yawed

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272497.54617761.3
3Display Results2492490.0763276.3
 (SQL Overall)1786912497.77822973.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.