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

111 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
subtext164765(None) 
subtest9513961subtest
subtexts1744901subtexts
subject18258632subject
sublet82827242suble_t
subnet82520932subne_t
subrent9315082subrent
subsect112611842subsect
subset83122582subse_t
subtaxa1644492subtaxa
subteen938522subteen
subtend1037102subtend
subtests1037532subtests
subtlest10511362subtlest
subvert12312892subvert
urtext1337432_urtext
context163913433context
curtest9713963curtest
cutest85820143cu_test
justest1449893justest
mutest84218053mu_test
obtect10129633_obtect
obtest81213013_obtest
outeat62824533ou_teat
pretext1639663pretext
rubiest92914423rubiest
saltest71916513saltest
septet8921133septe_t
sestet6826203seste_t
sext117338093s___ext
sextet13916873sexte_t
sobeit8315363sob_eit
softest10310603softest
stent55634513s__tent
stet45947323s__te_t
suavest10310623suavest
subagent1147913subagent
subbed114116673subbe_d
subcell1146763subcell
subcult1149613subcult
subdean1037403subdean
subdeb1137523subde_b
subdebs1236483subdebs
subdepot1344683subdepot
subduct12107583subduct
subedit1049403subedit
suber74924503sub_e_r
suberect12410873suberect
subers85722643sub_ers
subfix1835073subfix_
subhead1387693subhead
subitem1138553subite_m
subitems1245493subitems
subjects19226533subjects
sublets92616703sublets
sublot82315523sub_lot
submenu1148363submenu
submit10312673sub_mit
subnets92512083subnets
subpart11311133subpart
subpena1136683subpena
subplot1158143subplot
subpotent1346213subpotent
subrents10310293subrents
subsea82610203subse_a
subsects12267903subsects
subsere9311443subsere
subsets92813103subsets
subsist9311573subsist
subtask1335723subtask
subtaxon1742743subtaxon
subteens1037423subteens
subtenant1146503subtenant
subtends1136173subtends
subtextual1952113subtextual
subtheme1544333subtheme
subtile91912623subtile
subtilest1148813subtilest
subtilty1345453subtilty
subtle82113433subt_le
subtler92910853subtler
subtlety1345063subtlety
subtly11249263subt_ly
subtone9310343subtone
subtract1249583subtract
subtrend1145193subtrend
subtype1444203subtype
subunit948953subunit
subvene1238493subvene
subverts1336973subverts
subzero1835613subzero
suet46754823su__e_t
suggest9310863suggest
suite54829563suite__
suited74019423suite_d
suiter64121813suite_r
suiters73618883suiters
suites63727403suite_s
sunbelt939233sunbelt
sunket103721363sunke_t
sunset63723633sunse_t
surest65026763su_rest
surfeit10310343surfeit
surtax1337843surtax_
surtout7411683surtout
suspect1158513suspect
suttee63721543sutte_e
suttees74114063suttees
text116033933___text
unvext1658173_unvext
urtexts1433143_urtexts

Search took 7 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.423422437.4
2DLD Change Limit1340271116.06322105.7
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.53227356.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.