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

91 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
sunbeam114605(None) 
sunbeams1243961sunbeams
sunbeamy1542351sunbeamy
outbeam1137972outbeam
sunbelt939232sunbelt
unbear889162_unbear
unseam83313142_unseam
abeam9316533__abeam
beam86939233___beam
bugbear1233953bugbear
cudbear1233333cudbear
cuneal8611513cun_eal
dunam8313733dun__am
eyebeam1443563eyebeam
gunboat1047363gunboat
hornbeam1543593hornbeam
inseam8329993_inseam
moonbeam1443233moonbeam
outbeams1236063outbeams
scream104814253s_cream
seam66645973s___eam
shebean1235763shebean
sneak96016173s_n_eak
sneap75514823s_n_eap
soybean1243953soybean
steam76322933s__team
stream84717293s_tream
suba64926603su_b_a_
subah106015213su_b_ah
subas74724073su_b_as
subbed114116673subbe_d
subdean1037403subdean
suber74924503su_be_r
subers85722643su_bers
subgum1136133su_bgum
subhead1387693subhead
subnet82520933subne_t
subnets92512083subnets
subpar1048663su_bpar
subsea82610193subsea_
subway1447073su_bway
sunback1548153sunback
sunbath1236423sunbath
sunbelts1044673sunbelts
sunbird1044743sunbird
sunbow1145823sunb_ow
sunbows1236023sunbows
sunburn945133sunburn
sundae7312873sun_dae
sundaes8313093sundaes
sundeck1445273sundeck
sunder74019823sunde_r
sunders84120053sunders
sundew10369693sunde_w
sundews11398153sundews
sundial859863sundial
sunken103511783sunke_n
sunket103721363sunke_t
sunkets113511283sunkets
sunlamp1144163sun_lamp
sunless73013693sunless
sunna55016063sun_na_
sunnah9369353sun_nah
sunnas63914563sun_nas
sunned74216323sunne_d
sunray9310123sun_ray
sunroom947013sunroom
sunset63723633sunse_t
sunsets72911573sunsets
suntan62613003sun_tan
surreal739233surreal
unban72114333_unb_an
unbar71913613_unb_ar
unbe65319273_unbe__
unbears998043_unbears
unbelt83015693_unbelt
unbend9269773_unbend
unbent83216593_unbent
undead82711903_undead
unhelm1136863_unhelm
unjam1448723_un_jam
unlead73312373_unlead
unread73412673_unread
unreal64414453_unreal
unseal63315473_unseal
unseams9338913_unseams
unseat64221023_unseat
upbear1096493_upbear
upbeat10911513_upbeat
usnea539393usn_ea_
usneas638333usn_eas

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.390458182.1
2DLD Change Limit134027916.92319359.7
3Display Results91910.0303033.3
 (SQL Overall)178691917.34324334.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.