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

94 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
suburbed134514(None) 
subbed114116672sub__bed
subbreed1345872subbreed
suborned1137302suborned
suburb1037162suburb__
suburban1244452suburban
suburbia1243962suburbia
suburbs1136502suburb_s
sunburned1243562sunburned
sutured8310372sutur_ed
augured987193augur_ed
barbed115121313__barbed
blurbed12337613_blurbed
bulbed114312773__bulbed
burbled124312673__burbled
buried94822373__buried
burked135220883__burked
burled94825383__burled
burned95818963__burned
burped116215503__burped
burred95820723__burred
curbed114615873__curbed
dubbed124113213dub__bed
fubbed144711243fub__bed
outburned1245213outburned
reburied1137913reburied
rubbed114515083rub__bed
sabbed114518083sab__bed
sabered103213023saber_ed
sabred95916533sab_r_ed
scoured103811153scour_ed
scourged1234573scourged
scrubbed1533853scrubbed
secured1059723secur_ed
slubbed12339283s_lubbed
slurped10368753s_lurped
slurred8359193s_lurred
snubbed12347443s_nubbed
sobbed113516263sob__bed
sobered102912433sober_ed
sorbed94916523s__orbed
sourced1038453s_ourced
soured74921863s_our_ed
splurged1243923splurged
spurned10339263s_purned
spurred103610623s_purred
spurted103111973s_purted
stubbed12378083s_tubbed
subarea939403subar_ea
subarid10310653subar_id
subbreeds1443573subbreeds
subduced14105163subduced
subducted1544223subducted
subdued11107113sub_dued
suberised1299033suberised
suberized2198823suberized
subgrade1246053subgrade
sublated11311503sublated
sublimed1337213sublimed
submerged1544603submerged
submersed1445863submersed
suborder1146663suborder
suborner1047383suborner
subrule939643subrule_
subrules1039723subrules
subscribed1743823subscribed
subserved1545143subserved
subsided1257663subsided
subsumed1344943subsumed
subtrend1145193subtrend
subtribe1246463subtribe_
subtribes1346233subtribes
suburbans1344093suburbans
suburbias1343903suburbias
subvened1436423subvened
subverted1545443subverted
subwayed1753723subwayed
succumbed1842073succumbed
sugared938583sugar_ed
sulfured1236113sulfur_ed
superbad1347263superbad
superber1239693superber
supered10316123super_ed
surfed103814463s__urfed
surged84118883s__urged
suture6313203sutur_e_
sutures7314223sutur_es
tubbed114712223tub__bed
unbarbed13217753unbarbed
unburied11208513unburied
unburned11227413unburned
uncurbed1346903uncurbed
unurged939143_unurged
usurped1035153_usurped

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 Filter1786911461620.423422437.4
2DLD Change Limit146162947.17020385.2
3Display Results94940.0332848.5
 (SQL Overall)178691947.62623431.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.