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 “sunbath” 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
sunbath123642(None) 
sunbathe1344031sunbathe
sunbaths1344381sunbaths
sabbath1445392sabbath
snath86419802s_n_ath
subah106015212su_ba_h
sunback1548152sunback
sunbathed1543312sunbathed
sunbather1443022sunbather
sunbathes1444112sunbathes
sunnah9369352sunna_h
bath95940083___bath
beneath1236973beneath
cuneate9311723cuneate
eurybath1642333eurybath
gunboat1047363gunboat_
gunboats1144823gunboats
isobath1244613isobath
jubbah2034353jubba_h
kurbash1643803kurbash
lunate6316043lun_ate
neath86020283__neath
numbat10312083numbat_
numbats1137673numbats
punkah15347093punka_h
rubati8299693ru_bati
rubato8319683ru_bato
runback1556603runback
sabbat10314713sabbat_
sabbaths1543973sabbaths
sabbats1138633sabbats
senate63725143sen_ate
sensate7311883sensate
sheath12412893s_heath
shibah14387473shiba_h
sinuate7412163sinuate
snash84815673s_n_ash
snatch114310603s_n_atch
snathe94415113s_n_athe
snaths95112913s_n_aths
sonata6313223son_ata
sorbate9311733sorbate
stenobath1462873stenobath
strath93216373s_trath
suba64926603su_ba__
subahs114512383su_bahs
subas74724073su_ba_s
subatom1147053su_batom
subbase1139323subbase
subbass1138033subbass
subito8410453su_bito
sublate9315363sublate
subnet82520933subnet_
subnets92512083subnets
succah1336643succa_h
succoth1445093succoth
sukkah12123733sukka_h
sukkoth1342093sukkoth
sulcate9314423sulcate
sulfate10311653sulfate
sumach135310113su_mach
summate113611663summate
sunbaked1545533sunbaked
sunbathers1542483sunbathers
sunbathing1642933sunbathing
sunbeam1146053sunbeam
sunbeams1243963sunbeams
sunbeamy1542353sunbeamy
sunbelt939233sunbelt
sunbelts1044673sunbelts
sunbird1044743sunbird
sunbow1145823sunb_ow
sunbows1236023sunbows
sunburn945133sunburn
sundae7312873sunda_e
sundaes8313093sundaes
sunfast1038503sunfast
sunfish1338883sunfish
sunket103721363sunket_
sunkets113511283sunkets
sunlamp1144163sunlamp
sunland837473sunland
sunlit61516103sunlit_
sunna55016063sunna__
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunray9310123sunra_y
sunrays1037083sunrays
sunset63723633sunset_
sunsets72911573sunsets
suntan62613003sunta_n
suntans72111733suntans
sunward1137653sunward
surah86823253su_ra_h
surbase939793surbase
swath115920383s__wath
synth113711823syn__th
tubate82813173tu_bate
turbeth1274713turbeth
turbith1267113turbith
unbale83616403_unbale
unban72114333_unba_n
unbans81912623_unbans
unbar71913613_unba_r
unbars82113033_unbars
unbated103317733_unbated
unbathed1437223_unbathed
unearth1037063_unearth
unfaith1345783_unfaith
unhat81119263_unhat_
unhats91110623_unhats
unlash938793_unlash
unlatch1245053_unlatch

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 Limit1340271137.01319111.2
3Display Results1131130.0502260.0
 (SQL Overall)1786911137.21924752.9
 
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.