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

64 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
subunits104662(None) 
subunit948951subunit_
subedits1146712subedits
submits1139752sub_mits
subnets92512082sub_nets
subtunics1343352subtunics
autunite856693autunite
autunites946203autunites
binits85716673__binits
bundts95010843__bundts
bunts75729803__bun_ts
cubits103714033cub__its
qubits173710353qub__its
schuits1235823schu_its
sennits73811283s_ennits
shunts95712023s_hun_ts
snits54124833s___nits
squints16339033s_quints
strunts7429543strun_ts
stunts65615253s_tun_ts
subbings13238483subbings
subcults1246933subcults
subcutis1246293subcuti_s
subducts13106093subducts
subedit1049403subedit_
suberins10315093suberins
subito8410453sub__ito
subjects19226533subjects
subjoins1745453subjoins
sublets92616703sub_lets
sublimits1345563sublimits
sublines10315783sublines
sublots92410913sub_lots
submiss1138083sub_miss
submit10312673sub_mit_
subnet82520933sub_net_
subparts1246903subparts
subplots1255773subplots
subrents10310293subrents
subrings11229883subrings
subsects12267903subsects
subsets92813103sub_sets
subsist9311573sub_sist
subsists1037993subsists
subsite9412873sub_site
subsites10312783sub_sites
subsoils1076653subsoils
subtests1037533subtests
subtexts1744903subtexts
subtonics1345433subtonics
subtunic1244263subtuni_c
subulate10312743subulate
suburbias1343903suburbias
suburbs1136503subu_rbs
subverts1336973subverts
suints64617783su_in_ts
suits55028053s__u_its
summits1137983su_mmits
sunbursts1143033sunbursts
sunsuits845963sunsuits
surfeits1146223surfeits
tubulins10106293tubulins
units54923433___units
unknits1135553_unknits

Search took 9 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.406440125.6
2DLD Change Limit146162647.72018932.9
3Display Results64640.0302133.3
 (SQL Overall)178691648.15621909.1
 
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.