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 “sunbathe” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

46 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
sunbathe134403(None) 
sunbath1236421sunbath_
sunbathed1543311sunbathed
sunbather1443021sunbather
sunbathes1444111sunbathes
sunbaths1344381sunbaths
snathe94415112s_n_athe
sunbathers1542482sunbathers
unbathed1437222_unbathed
bathe105822883___bathe
cuneate9311723cuneat_e
lunate6316043lun_at_e
sabbath1445393sabbath_
sabbaths1543973sabbaths
scathe114414993s__cathe
senate63725173sen_at_e
sensate7311893sensat_e
sheathe1348993s_heathe
sinuate7412163sinuat_e
snath86419803s_n_ath_
snathes104816493s_n_athes
snaths95112913s_n_aths
sorbate9311733sorbat_e
spathe115115693s__pathe
subah106015213su_ba_h_
subahs114512383su_ba_hs
subatom1147053su_batom
subbase1139323subba_se
sublate9315363sublat_e
subniche1554253subniche
subtle82113433su_b_tle
sulcate9314423sulcat_e
sulfate10311653sulfat_e
summate113611663summat_e
sunback1548153sunba_ck
sunbaked1545533sunbaked
sunbathing1642933sunbathing
sundae7312873sunda__e
sunnah9369353sunna_h_
sunnahs10326593sunna_hs
surbase939793surba_se
swathe125514113s__wathe
tubate82813173tu_bat_e
unbale83616403_unba_le
unbated103317733_unbated
unswathe1444603_unswathe

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 Filter1786911461620.406440125.6
2DLD Change Limit146162466.42322756.0
3Display Results46460.0133538.5
 (SQL Overall)178691466.84226116.8
 
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.