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

120 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
subsect11261184(None) 
subject18258631subject
subsects12267901subsects
subset83122581subse_t
subduct12107582subduct
suberect12410872suberect
subjects19226532subjects
sublet82827242suble_t
subnet82520932subne_t
subrent9315082subrent
subsea82610192subse_a
subsector1344402subsector
subsere9311442subsere
subsets92813102subsets
subsist9311572subsist
subtest9513962subtest
subtext1647652subtext
subvert12312892subvert
sunset63723632sunse_t
suspect1158512suspect
abject17137703_abject
absent84016993_absent
bisect10312873_bisect
cusec94614903cu_sec_
cusecs10509153cu_secs
dissect103614133dissect
exsect1558503_exsect
fubsiest13258413fubsiest
gusset7316433gusse_t
insect83916583_insect
object17135803_object
obtect10129633_obtect
outsert72819513outsert
outset64027453outse_t
prosect11313393prosect
resect84424703_resect
resubject2042313resubject
rubiest92914423rubiest
russet6319433russe_t
sect67443623___sect
select82621173s_elect
sobeit8315343sob_eit
suavest10310623suavest
subagent1147913subagent
subbed114116673subbe_d
subcell1146743subcell
subcult1149603subcult
subdean1037403subdean
subdeb1137523subde_b
subdebs1236483subdebs
subdepot1344683subdepot
subduce12106983subduce
subducts13106093subducts
subecho1445073sub_echo
subedit1049403subedit
suber74924503sub_e_r
subers85722643sub_ers
subhead1387693subhead
subjected2144773subjected
sublets92616703sublets
sublot82315523sub_lot
submenu1148363submenu
submit10312673sub_mit
subnets92512083subnets
subpart11311123subpart
subpena1136673subpena
subplot1158133subplot
subrace11313003subrace
subrents10310293subrents
subs66037123subs___
subsale9310543subsale
subsection1496783subsection
subsectors1444483subsectors
subsense1046963subsense
subseres10312423subseres
subserve1346463subserve
subshaft1645173subshaft
subshell1344873subshell
subside10410453subside
subsidy1345973subsidy
subsists1037993subsists
subsite9412863subsite
subsoil967293subsoil
subspace1445683subspace
substate101711083substate
subsume1146713subsume
subteen938523subteen
subtend1037103subtend
subtests1037533subtests
subtexts1744903subtexts
subtlest10511353subtlest
subtract1249583subtract
subunit948943subunit
subvene1238493subvene
subverts1336973subverts
subzero1835613subzero
sudsed83911373sudse_d
sudser73511283sudse_r
sudsers83310413sudsers
sudses74114503sudse_s
sudsiest939613sudsiest
suet46754823su__e_t
suggest9310863suggest
sunbelt939233sunbelt
sundeck1445273sundeck
sunket103721363sunke_t
sunsets72911573sunsets
sunspot947163sunspot
sunsuit748693sunsuit
surest65026763su_rest
surfeit10310343surfeit
suspects1254863suspects
sussed75015533susse_d
susses64221053susse_s
trisect939733trisect
unseat64221023_unseat
unsent63820963_unsent
unset54532433_unse_t
upsent83314063_upsent
upset73222593_upse_t

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 Filter1786911340270.266671770.7
2DLD Change Limit1340271208.20316338.8
3Display Results1201200.0631904.8
 (SQL Overall)1786911208.53220943.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.