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 “subdeans” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
subdeans113720(None) 
subdean1037401subdean_
subclans1247412subclans
subdeacons1552652subdeacons
subdebs1236482subde_bs
subduals1156292subduals
subheads1496532subheads
subideas1146442subidea_s
subpenas1246902subpenas
subteens1037422subteens
suddens9308782sudde_ns
suldans8299722suld_ans
beans75734693__b_eans
burdens1039713burde_ns
cudbears1343483cudbears
deans66131393___deans
dudeens934863du_deens
guldens9356573gulde_ns
lurdans837073lurd_ans
quadrans1866363quadrans
queans153110753qu__eans
rubdowns1473083rubdowns
saddens9309603sadde_ns
sedans74816093s_ed_ans
shebeans1344703shebeans
skeans104512913s__keans
soddens9348413sodde_ns
soldans83210403sold_ans
soudans8309353soud_ans
soybeans1343283soybeans
speans85417143s__peans
subadars11125093subadars
subahs114512383sub__ahs
subareas1038623subarea_s
subas74724073sub__a_s
subbass1138033sub_bass
subcells1246283subcells
subclan1147173subclan_
subclass1246623subclass
subdeacon1452773subdeacon
subdealer1245223subdealer
subdealers1344113subdealers
subdeb1137523subde__b
subdepot1344683subdepot
subdepots1443163subdepots
subdual10126713subdua_l
subduces1397263subduces
subducts13106093subducts
subduers1186363subduers
subdues1099893subd_ues
subduing1235823subduing
subdwarf1743383subdwarf
subdwarfs1841713subdwarfs
subedits1146713subedits
suberins10315093suberins
subers85722643sub_e_rs
subgenus1145753subgenus
subgoals1145553subgoals
subhead1387693subhea_d
subhumans1642843subhumans
subidea1037533subidea__
subjects19226533subjects
subjoins1745453subjoins
sublease1038383sublease
subleases1148653subleases
sublets92616703suble_ts
submenu1148363subme_nu
submenus1245903submenus
subnets92512083subne_ts
subocean1244803subocean_
suborns939493sub_orns
subpena1136673subpe_na
subpoenas1344413subpoenas
subrent9315083subre_nt
subrents10310293subrents
subsea82610193subsea__
subsects12267903subsects
subsense1046963subse_nse
subseres10312423subseres
subsets92813103subse_ts
subteen938523subteen_
subtenant1146503subtenant
subtenants1244553subtenants
subtend1037103subte_nd
subtends1136173subtends
subtests1037533subtests
subtexts1744903subtexts
suburbans1344093suburbans
subvene1238493subve_ne
subvenes1339633subvenes
subverts1336973subverts
subways1536163sub_ways
sudden83310833sudde_n_
suedes73918113suede__s
suldan72611043suld_an_
sultans72411833su_ltans
sunbeams1243963sunbeams
sundaes8313093sund_aes
sundecks1544253sundecks
sunders84120053sunde_rs
sundews11398153sunde_ws
sundials946753sundials
sundowns1285433sundowns
suntans72111733su_ntans
surgeons947033surgeons

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.1561145455.1
2DLD Change Limit1461621057.01620832.7
3Display Results1051050.0303500.0
 (SQL Overall)1786911057.20224811.3
 
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.