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

140 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
waxweed213292(None) 
waxweeds2242151waxweeds
axseed1456992_axseed
mayweed1634162mayweed
ragweed1235072ragweed
tarweed1137342tarweed
wawled133811702wa_wled
waxed166018482wax__ed
weeweed1435182weeweed
agreed84712503_agreed
anteed75616113_anteed
atween9166613_atween
awed88436033_a_w_ed
awee76336643_a_wee_
awned96615953_a_wned
axed128829613_ax__ed
axised14438963_axised
axled135315813_ax_led
axseeds1533393_axseeds
bawled124415693ba_wled
burweed1347823burweed
cawed116627063ca_w_ed
cudweed1444213cudweed
daneweed1344053daneweed
dawed106222813da_w_ed
dawned113912093da_wned
dawted11489683da_wted
dyeweed1543203dyeweed
exceed1636173_exceed
fawned134910423fa_wned
faxed166220533fax__ed
flaxseed1942573flaxseed
gawked15468763ga_wked
gawped13509073ga_wped
gumweed1433943gumweed
hawed126025423ha_w_ed
hawked174712673ha_wked
hawkweed2242203hawkweed
hayseed1435633hayseed
hogweed1534443hogweed
jawed165517373ja_w_ed
knapweed1842443knapweed
lawed96028323la_w_ed
mawed115824743ma_w_ed
maxed155821193max__ed
maxwell1942513maxwell
mayweeds1742993mayweeds
paveed12438893pa_veed
pawed115725613pa_w_ed
pawned124513283pa_wned
pigweed1465093pigweed
pinweed1346933pinweed
ragweeds1342903ragweeds
raxed135622663rax__ed
razeed163710013ra_zeed
sauteed8349613sauteed
sawed95628403sa_w_ed
seaweed11108813seaweed
snapweed1443453snapweed
tarweeds1244273tarweeds
tawed95926193ta_w_ed
tawsed10499743ta_wsed
taxed135620293tax__ed
taxied14509373tax_ied
tweed94915093__tweed
wabbled153311443wabbled
wadded124014173wa_dded
waddied13358563waddied
waddled133611643waddled
waded106024753wa__ded
wafered14288433wafered
waffed16459793wa_ffed
waffled17357523waffled
wafted134012143wa_fted
waged104822783wa__ged
wagered12299333wagered
wagged124616123wa_gged
waggled13389363waggled
wagoned1256223wagoned
waifed134011033wa_ifed
wailed104823593wa_iled
waired106015833wa_ired
waisted114210943waisted
waited103819773wa_ited
waitered1238753waitered
waived134511283wa_ived
waked135626753wa__ked
wakened1546873wakened
waled94330993wa__led
walked145313783wa_lked
walled104021293wa_lled
walleyed1534153walleyed
waltzed2033493waltzed
wambled153610753wambled
wandered132110793wandered
waned95831783wa__ned
wangled123312413wangled
wanked144517153wa_nked
wanned104318013wa_nned
wanted104319723wa_nted
wapped144416473wa_pped
warbled133212163warbled
warded115021043wa_rded
wared96339873wa__red
warhead1436603warhead
warked144421213wa_rked
warmed124516893wa_rmed
warned104018913wa_rned
warped124816413wa_rped
warred104019843wa_rred
warsled112910443warsled
warted104223233wa_rted
washed135521503wa_shed
wasted104423023wa_sted
watched163012823watched
watered113014953watered
waterweed1644623waterweed
wattled113610503wattled
wauked144210573wa_uked
wauled104713963wa_uled
waved125223583wa__ved
wavered142910433wavered
waxen154911813wax__en
waxer154317483wax__er
waxers164014303wax_ers
waxes155825503wax__es
waxier16439903wax_ier
waxiest173510883waxiest
waxwing2154723waxwing
waxwork24104883waxwork
waxworm2264563waxworm
wayward1736053wayward
weed85637513___weed
weewee12310083weewee_
weewees1336563weewees
wowed124023773w_ow_ed
yawed126022453ya_w_ed
yawled13459983ya_wled
yawned13509843ya_wned
yawped15528103ya_wped

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 Limit1340271406.86019537.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.06225303.2
 
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.