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

57 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
sunburned124356(None) 
unburned11227411_unburned
outburned1245212outburned
suborned1137302su_borned
suburbed1345142su_burbed
sunburn945132sunburn__
sunburns1044282sunburn_s
sunburnt1045602sunburn_t
unburied11208512_unburied
unturned9228562_unturned
burned95818963___burned
inturned9268313_inturned
inurned8328053_in_urned
sideburned1451373sideburned
sojourned1761493sojourned
spurned10339263s__purned
subbreed1345873su_bbreed
suborner1047383su_borner
subtrend1145193su_btrend
subvened1436423su_bvened
sulfured1236113sulfur_ed
sunbaked1545533sunb_aked
sunbathed1543313sunbathed
sunbird1044743sunbir__d
sunbonnet1144943sunbonnet
sunburning1343353sunburning
sunburst1045183sunbur_st
sunbursts1143033sunbursts
sundered10312153sunder_ed
sundowned1442683sundowned
sunned74216323sun___ned
suntanned1044013suntanned
sutured8310373su_tur_ed
unbanned11279113_unbanned
unbarbed13217753_unbarbed
unbarred11238713_unbarred
unblurred1243003_unblurred
unboned103014223_unb_oned
unbred92613303_unb_r_ed
unburden11124293_unburden
unburdened1442473_unburdened
unburnt977413_unburn_t
unbusted11258773_unbusted
uncurbed1346903_uncurbed
uncured10513233_uncur_ed
uncurled1168963_uncurled
uncursed1148973_uncursed
unearned9310063_unearned
unfurled1277203_unfurled
unmourned1254153_unmourned
unpruned1136863_unpruned
unpurged1236293_unpurged
untuned82010823_untu_ned
unurged939143_un_urged
unwarned1238453_unwarned
upturned11214013_upturned
windburned1751153windburned

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 Filter1786911486410.436409841.7
2DLD Change Limit148641577.05021083.8
3Display Results57570.0134384.6
 (SQL Overall)178691577.49923828.6
 
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.