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

96 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
subsumes124692(None) 
subsume1146711subsume_
subsumed1344941subsumed
subcutes1238582subcutes
subduces1397262subduces
subdues1099892subdu_es
subgums1235892subgum_s
sublimes12310032sublimes
subrules1039722subrules
subsales10310122subsales
subseres10312422subseres
subsides11410822subsides
subsites10312782subsites
assumes967163_assumes
blumes105917793__blumes
brumes106417073__brumes
consumes12310413consumes
lususes736713lu_suses
presumes1239843presumes
pursues94111373pursu_es
resumes9313373_resumes
satsumas1043573satsumas
sebums10369813seb_um_s
seisures838273seisures
sesames9310743s_esames
spumes1021314883s__pumes
subbases1239063subbases
subcauses1346213subcauses
subcodes1338143subcodes
subcults1246933subcults
subcutis1246293subcutis
subduals1156293subduals
subduce12106983subduce_
subduced14105163subduced
subducts13106093subducts
subdue9128493subdu_e_
subdued11107113subdu_ed
subduer10107033subdu_er
subduers1186363subduers
subfiles131710723subfiles
subfixes20207493subfixes
subframes1645853subframes
subfuscs1543753subfuscs
subgum1136133subgum__
subhuman1543793subhuman
subhumans1642843subhumans
subhumid1642833subhumid
subitems1245493subitems
sublates10315003sublates
sublime11310363sublime_
sublimed1337213sublimed
sublimer1237613sublimer
sublimers1345773sublimers
sublimest1346713sublimest
sublines10315783sublines
subraces12313033subraces
subrule939643subrule_
subsale9310543subsale_
subsamples1652423subsamples
subscales1347343subscales
subsea82610193subs__ea
subsects12267903subsects
subsense1046963subsense
subsenses1147473subsenses
subsere9311443subsere_
subseries11312933subseries
subserves1447183subserves
subset83122583subs__et
subsets92813103subs_ets
subside10410453subside_
subsided1257663subsided
subsider1138243subsider
subsiders1246053subsiders
subsidies1248423subsidies
subsists1037993subsists
subsite9412873subsite_
subsoils1076653subsoils
subspaces1545673subspaces
substages12127353substages
substates111410333substates
subsuming1444273subsuming
subthemes1644113subthemes
subtones10311383subtones
subtypes1544553subtypes
suburbs1136503sub_urbs
subvenes1339633subvenes
subzones1947223subzones
succumbs1642423succumbs
sudses74114503suds__es
suffuses1435833suffuses
sunsuits845963sunsuits
supremes1238363supremes
surnames1037273surnames
susses64221053su_s_ses
sutures7314223su_tures
tubules9310233tub_ules

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.453394461.4
2DLD Change Limit146162967.17020385.2
3Display Results96960.0462087.0
 (SQL Overall)178691967.66923300.4
 
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.