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

116 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
bethorns133732(None) 
bethorn1238641bethorn_
althorns1146732althorns
benthons1337972bentho_ns
bethorned1544442bethorned
betons84919552bet_o_ns
bettors93312472bettor_s
bighorns1445252bighorns
boxthorns2143022boxthorns
dehorns11428362de_horns
leghorns1244902leghorns
thorns95314102__thorns
abettors1056133abettor_s
aethers103614943aether_s
alphorns1345223alphorns
althorn1047763althorn_
attorns738443_attorns
authors10311853author_s
bathers124720363bather_s
bathos116215633batho__s
bathoses13310463bathoses
batons85519423bat_o_ns
beacons11410733beaco_ns
becharms1745343becharms
beckons15279143becko_ns
beclowns1544683beclowns
bedgowns1543113bedgowns
bedsores1157633bedsores
begroans1145503begroans
beholds1336423be_holds
behoves15177353be_hoves
behowls1534443be_howls
belons84119413be_lo_ns
bemoans1138253be_moans
benthon1237693bentho_n_
benthos1238373bentho__s
benthoses1446693benthoses
benzoins1945573benzoins
beshouts1346763beshouts
betatrons1145083betatrons
bethank1666273beth_ank
bethanks1765313bethanks
bethels1238533beth_els
bethink1677203beth_ink
bethinks1765043bethinks
bethorning1644203bethorning
beths105519223beth___s
bethumps1741993bethumps
betokens14324573betokens
beton76022063bet_o_n_
betony114211583bet_o_ny
betroths1345633betroths
betters94422093better_s
bettor83612223bettor__
bevors111610343be_vor_s
beworms1437933be_worms
bicorns11338763b_icorns
bighorn1346063bighorn_
bitterns10428953bitterns
blethers13429613blether_s
bothers124317753bother_s
boxthorn2043693boxthorn_
buckthorns2151833buckthorns
bullhorns1443963bullhorns
buttons9310333butto_ns
citherns13338873citherns
cothurns1344523cothurns
dehorn10439653de_horn_
dehorts11379773de_horts
dethrone1247563dethrone
dethrones1347313dethrones
ephors11311403_ephor_s
ethers94518413_ether_s
ethions1038483_ethions
ethos85514193_etho__s
ethoses10311763_ethoses
exhorts1746313_exhorts
fetors91014473fet_or_s
firethorns1643123firethorns
foghorns1544113foghorns
futhorcs1643543futhorcs
futhorks1844603futhorks
hawthorns1842823hawthorns
horns86125333___horns
inkhorns1543583inkhorns
jetons134512613jet_o_ns
jetports1743533jetports
jettons1437273jetto_ns
lanthorns1246013lanthorns
leghorn1146223leghorn_
letdowns1243483letdowns
lutherns1136293lutherns
meteors94610013meteor_s
methods1338883metho_ds
nephrons1346853nephrons
networks1546143networks
newborns1343403newborns
plethoras1444803plethoras
pythons1537363pytho_ns
readorns938283readorns
retorn610923433ret_orn_
retorts76016513ret_orts
returns79712593ret_urns
saxhorns1843833saxhorns
senhoras11278283senhoras
senhores112810993senhores
senhors103512133senhor_s
setons64620173set_o_ns
tethers103815313tether_s
thorn85318703__thorn_
thorny12509843__thorny
thorons104511913__thorons
thorps113610893__thorps
tinhorns1145013tinhorns
wethers135214693wether_s
zitherns20376133zitherns

Search took 9 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.410435831.7
2DLD Change Limit1461621167.71618942.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.17221866.3
 
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.