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

77 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
sunburn94513(None) 
sunburns1044271sunburns
sunburnt1045601sunburnt
auburn836212au_burn
outburn936902outburn
suborn8310002su_born
suburb1037162su_burb
sunbird1044742sunbird
sunburned1243562sunburned
sunburst1045182sunburst
unborn83310812_unborn
unburnt977412_unburnt
auburns935573au_burns
burn65636423___burn
inborn8319133_inborn
inturn63411563_inturn
inurn53712863_in_urn
outburns1036063outburns
outburnt1057153outburnt
outturn737123outturn
sambur10469503sambur_
samburs11369343samburs
sandbur10105353sandbur_
sandburr11123223sandburr
sandburs11105623sandburs
santur6311273santur_
santurs7310763santurs
sojourn1442893sojourn
spurn74815453s__purn
stubborn1242873stubborn
suber74924503su_ber_
suberin9314563su_berin
subers85722643su_bers
suborns939483su_borns
suburban1244453su_burban
suburbs1136503su_burbs
sulfur937913sulfur_
sulfurs1037343sulfurs
sulfury1345163sulfury
sunback1548153sunback
sunbath1236423sunbath
sunbeam1146053sunbeam
sunbelt939233sunbelt
sunbirds1143903sunbirds
sunbow1145823sunb_ow
sunbows1236023sunbows
sunburning1343353sunburning
sunbursts1143033sunbursts
sunder74019823sunder_
sunders84120053sunders
sundown1186313sundown
sundry1057943sun_dry
sunken103511783sun_ken
sunn45423593sun___n
sunsuit748693sunsuit
suntan62613003sun_tan
sunup7313053sun_u_p
sunups837263sun_ups
sunward1137653sunward
suture6313203su_ture
synura935983syn_ura
unban72114333_unb_an
unbar71913613_unbar_
unbars82113033_unbars
unburden11124293_unburden
unburned11227413_unburned
unbusy1135213_unbusy
uncurb1037043_uncurb
uncurl839413_uncurl
unfurl937953_unfurl
unhurt9311253_unhurt
unpure82911533_unpure
unsure62815413_unsure
untorn63012343_untorn
unworn93411333_unworn
upturn8286243_upturn
windburn1442733windburn

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.1401276364.3
2DLD Change Limit134027777.11018850.5
3Display Results77770.0164812.5
 (SQL Overall)178691777.26624592.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.