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

206 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
dramedy143324(None) 
dramady1443551dramady
drammed13378072drammed_
draped105314362draped_
drapery13387942drapery
drapey125010582drape_y
drayed115911392drayed_
dreamed114310632dreamed_
framed125116522framed_
remedy1237872_remedy
tragedy1234792tragedy
alameda1035493alameda
arame75026623arame__
arames84622573arame_s
aramid93315613aramid_
aramids102810513aramids
armed86324433ar_med_
beamed115720733beamed_
blamed116017953blamed_
braced115420603braced_
braked135318693braked_
brambly16296253brambly
brandy124712063bra_ndy
braved124817443braved_
bravely15428233bravely
bravery15428133bravery
brayed124615783brayed_
brazed184717083brazed_
breamed124011593breamed_
comedy14378233_comedy
crammed143710123crammed_
cramped144712183cramped_
crampy154710993cram_py
craned96121653craned_
craped116120523craped_
crated94827773crated_
craved125417773craved_
crazed184714453crazed_
creamed123913713creamed_
creamery15385983creamery
daddy116212563d_a_ddy
daledh1133743d_aledh
dame77140313d_ame__
dames85435853d_ame_s
dammed124214793dammed_
damned104212913d_amned_
damped124315583d_amped_
damply14337893d_amply
dandy104416703d_a_ndy
dared75935013d_ared_
darked123919633darked_
darkey145212423darke_y
darned85018483darned_
darted84620923darted_
dated75530993d_ated_
datedly1236023d_atedly
dawed106222813d_awed_
dazed165919363d_azed_
dazedly2134063d_azedly
deaned84620453deaned_
deanery1137613deanery
deaved114916553deaved_
deedy104315893d__eedy
deemed104713063deemed_
defamed14309833defamed_
derated93623503derated_
dialed84716453dialed_
diamide1138473diamide
dimmed124110323dimmed_
doated84118183doated_
domed95423263d_omed_
doomed104113293doomed_
drabbed13428723drabbed_
drably123511613dra_bly
dracena1034923dracena
draffy16486633dra_ffy
drafted12439033drafted_
drafty13638933dra_fty
dragee84415603drage_e
dragees9359483dragees
dragged11379563dragged_
draggy12346823dra_ggy
drained93713253drained_
drake104918303drake__
drakes114715863drake_s
dram75832003dram___
drama85117413dram__a
dramas95814653dram_as
dramedies1345123dramedies
drams86025833dram__s
drape85319633drape__
draper94315693drape_r
drapers105313353drapers
drapes95419653drape_s
dratted9358593dratted_
drave95219273drave__
drawee104413823drawe_e
drawees11378363drawees
drawer104711363drawe_r
drawers113610073drawers
drawled12368343drawled_
drawly134910723dra_wly
dray85428093dra___y
draymen1335233drayme_n
dreaded103612023dreaded_
dreamer104110843dreame_r
dreamers11369003dreamers
dreamily1435143dreamily
dreamy12509993dream__y
dreed75222843dr_eed_
dried75321383dr_ied_
dromedary1652073dromedary
droned84616863droned_
droved114611643droved_
drumly1235703drum_ly
drummed13306323drummed_
duramen1096903durame_n
duramens1195153duramens
erased74816753erased_
famed115928343_famed_
farmed125117653farmed_
flamed124618973flamed_
foamed126014403foamed_
frame105821803frame__
framer114817443frame_r
framers125113823framers
frames115119863frame_s
frayed135012163frayed_
gamed95126393_gamed_
gamely124711913_gamely
gamey115320553_game_y
graced105217903graced_
graded94919553graded_
gramary1355903gramary
gramercy1641923gramercy
grapery13457953grapery
grapey126012303grape_y
grated84523923grated_
graved114818813graved_
gravely14469063gravely
grayed115415643grayed_
grazed174115913grazed_
greedy11518853gr_eedy
grimed104714093grimed_
harmed125218833harmed_
irately1047683irately
lamed85235293_lamed_
lamedh12476363_lamedh
lameds94812033_lameds
lamely114013223_lamely
loamed94414613loamed_
mamey125418833_mame_y
named85223063_named_
namely113711323_namely
orated74221503orated_
prated94924923prated_
prayed124815433prayed_
premed114617763premed_
premeds12389593premeds
primed115118913primed_
primely1457723primely
raced87635313_raced_
raged74829453_raged_
raggedy13334663_raggedy
raked105831423_raked_
ramada9310183_ramada
ramee74633853_rame_e
ramees84620893_ramees
ramen75625193_rame_n
ramet75743143_rame_t
ramets83517393_ramets
ramify14268753_ramify
rammed113117303_rammed_
rammy124312493_ram_my
ramped114617903_ramped_
randy95022083_ra_ndy
raped85334623_raped_
rared65738323_rared_
rarefy12296343_rarefy
rarely93513653_rarely
rased65033933_rased_
rated65441383_rated_
raved94931433_raved_
raxed135622663_raxed_
rayed95127503_rayed_
razed155027983_razed_
reamed94326123reamed_
reedy910020293_r_eedy
rimed84826373_rimed_
roamed95215093roamed_
seamed94823883seamed_
shamed125120213shamed_
tamed85528513_tamed_
tamely113711953_tamely
teamed95418593teamed_
traced94821583traced_
tracery12399793tracery
traded85717683traded_
tramel84113713trame_l
tramell9398703tramell
tramels93812493tramels
trammed123810713trammed_
tramped124312433tramped_
trampy13499253tram_py
tramway1544863tramway
warmed124516893warmed_

Search took 7 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.423422437.4
2DLD Change Limit1340272066.18621666.2
3Display Results2062060.0633269.8
 (SQL Overall)1786912066.67226782.2
 
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.