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

113 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
bethinks176504(None) 
bethanks1765311bethanks
bethink1677201bethink_
methinks1775191methinks
rethinks1576031rethinks
behinds1335282be_hinds
betaines10313292betaines
bethank1666272bethank_
rethink1488882rethink_
thinks134613362__thinks
unthinks1574502unthinks
bashings144311243bashings
bathing134816243bathin_g
batiks1239373bat_i_ks
battiks1337143batti_ks
battings114010573battings
beadings123711783beadings
bearings113912253bearings
beatings114113233beatings
beatniks1444043beatni_ks
bechalks1944793bechalks
beddings13407923beddings
bedticks1774163bedticks
beduins1039123beduin_s
beehives1644483beehives
beelines103312803beelines
begins94415303be_gin_s
beguines11127213beguines
behind1238063be_hin_d
beings94613033be__ings
bellings113811153bellings
beltings11369253beltings
beltlines1135963beltlines
benthons1337973benthon_s
benzines1938213benzines
benzins1838693benzin_s
bepaints1235113bepaints
berlines102315453berlines
berlins93216013berlin_s
berthing14209593berthin_g
betaine9413783betain_e
bethanked1943283bethanked
bethels1238533beth_els
bethinking2044043bethinking
bethorns1337323bethorns
beths105519223beth___s
bethumps1741993bethumps
betides104915263bet_ides
betimes115114413bet_imes
betises94816123bet_ises
betonies10413063betonies
betons84919553bet_on_s
betting103921403bettin_g
beyliks1634853beyli_ks
birthings15254623birthings
bittings11339293bittings
blinks124613573b__links
bohunks1632943b_ohunks
boinks125211273b__oinks
bothies12414783bothi_es
breathings16234313breathings
brinks124616313b__rinks
bushings14348793bushings
chinks155817573__chinks
detains83716093detain_s
deticks1437353det_icks
echinus1236203_echinus
etchings14396293_etchings
ethanes103713513_ethanes
ethenes103313873_ethenes
ethics11169283_ethi_cs
ethinyl1343433_ethinyl
ethinyls1442873_ethinyls
ethions1038483_ethions
ethnics1236263_ethnics
ethnos947053_eth_nos
ethynes13377573_ethynes
hotlinks1574193hotlinks
lathings12469853lathings
methanes133812163methanes
misthinks1843353misthinks
naethings1343873naethings
nettings9288103nettings
nothings12266683nothings
outthinks1643313outthinks
overthinks2043263overthinks
pettings11349703pettings
ratfinks1542853ratfinks
reinks105012153re__inks
relinks114510223re_links
reshines112615443reshines
retains74522253retain_s
rethinker1643613rethinker
rethinkers1743023rethinkers
retinas74819353ret_inas
retines75134673ret_ines
retints74717013ret_ints
retsinas8387963retsinas
setlines8312743setlines
settings93810073settings
stinks105616833_st_inks
teethings1344233teethings
thanks134313133__thanks
thicks154511993__thicks
things104914303__things
think125018803__think_
thins85826333__thin_s
thunks13459033__thunks
tithings12327693tithings
unthink1457003unthink_
wettings12348403wettings
withins133511693within_s
zechins21137123zechin_s

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621137.03020791.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.51623774.7
 
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.