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

180 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
subhead138769(None) 
subheads1496531subheads
clubhead1662772clubhead
dumbhead17102742dumbhead
jughead1933642jughead
saphead1357772saphead
subbed114116672subbe_d
subdean1037402subdean
subsea82610192subsea_
subtend1037102subtend
sughed113610202sughe_d
ahead96817053__ahead
airhead1136993airhead
bead75937923__b_ead
behead1239923_behead
bighead14126653bighead
bluehead1444603bluehead
bowhead1636433bowhead
bread85523113__bread
buboed113010003buboe_d
bulkhead1863673bulkhead
bullhead1464783bullhead
bushed124822383bushe_d
butthead1454513butthead
cathead1338753cathead
clubheads1762483clubheads
cohead123811123_cohead
cubed105519703cub_e_d
drumhead1542653drumhead
dubbed124113213dubbe_d
dumbheads1882433dumbheads
egghead1343433egghead
fathead1437863fathead
fubbed144711243fubbe_d
godhead1334763godhead
gushed114816243gushe_d
head87137173___head
hophead16337923hophead
hothead14349293hothead
hushed134416673hushe_d
jarhead1835173jarhead
jubhah2142803jubh_ah
jugheads2042923jugheads
lubed85319893lub_e_d
lunkhead1642963lunkhead
lushed104218723lushe_d
mushed124420843mushe_d
ouched124316933ouche_d
outhear10910603outhear
outheard1288543outheard
outlead83311103outlead
outread82811093outread
pinhead13347073pinhead
pithead13419593pithead
pothead133810393pothead
pushed125017463pushe_d
redhead1257053redhead
rubbed114515083rubbe_d
rubied94312413rubie_d
ruched124314633ruche_d
rushed104419863rushe_d
sabbed114518083sabbe_d
sabed86526813sab_e_d
sabred95916533sabre_d
sapheads1466083sapheads
sashed105622943sashe_d
scubaed1236123scubae_d
shad86230913s__h_ad
shea76031573s__hea_
sheaf115424123s__heaf
sheal84927703s__heal
shear85424833s__hear
sheas86331793s__heas
shed86536153s__he_d
shend94719973s__hend
sherd96321153s__herd
shithead1535523shithead
shushed14348493shushe_d
sighed113712053sighe_d
skinhead1643063skinhead
slubbed12339283slubbe_d
slushed113611243slushe_d
smushed13368233smushe_d
snubbed12347443snubbe_d
sobbed113516263sobbe_d
softhead1545003softhead
sorehead1246973sorehead
soughed123811623soughe_d
southed114313993southe_d
sowbread1443193sowbread
spread9312533s_pread
stead65520273s__tead
stubbed12378083stubbe_d
suba64926603sub__a_
subacid1248473subacid
subadar10125583subadar
subah106015213sub__ah
subahdar1442913subahdar
subalar9118073subalar
subarea939403subarea_
subareas1038623subareas
subarid10310653subarid
subas74724073sub__as
subbreed1345873subbreed
subcell1146753subcell
subclan1147173subclan
subdeans1137203subdeans
subdeb1137523subde_b
subdebs1236483subdebs
subdual10126713subdual
subdued11107113subdued
suber74924503sub_e_r
subers85722643sub_ers
subfield1444753subfield
subgoal1046323subgoal
subgrade1246053subgrade
subheading1743793subheading
subhuman1543793subhuman
subhumid1642833subhumid
subidea1037533subidea_
subideas1146443subideas
subject18258633subject
sublease1038383sublease
subleased1246123subleased
sublet82827243suble_t
sublets92616703sublets
submenu1148363submenu
subnet82520933subne_t
subnets92512083subnets
subocean1244803subocean
suboral92011993suboral
suboval12216723suboval
subpar1048663sub_par
subpena1136673subpena
subpenaed1444773subpenaed
subpenas1246903subpenas
subrent9315083subrent
subsect112611843subsect
subsere9311443subsere
subset83122583subse_t
subsets92813103subsets
subshell1344883subshell
subteen938523subteen
subtends1136173subtends
subtest9513963subtest
subtext1647653subtext
subtheme1544333subtheme
subtrend1145193subtrend
subvene1238493subvene
subvened1436423subvened
subvert12312893subvert
subway1447073sub_way
subzero1835613subzero
succeed1235983succeed
sucked134120493sucke_d
sudsed83911373sudse_d
sued56537933su__e_d
sueded84014633suede_d
suited74019423suite_d
sulked114314703sulke_d
summed114014043summe_d
sunbeam1146053sunbeam
sunned74216323sunne_d
supped114415703suppe_d
surfed103814463surfe_d
surged84118883surge_d
surreal739233surreal
suspend1036013suspend
sussed75015533susse_d
towhead1435223towhead
tubbed114712223tubbe_d
tubed85818043tub_e_d
tushed104615893tushe_d
undead82711903_undead
unheard1136943_unheard
unlead73312373_unlead
unread73412673_unread
upheap13105213_upheap
upheld12115563_upheld
warhead1436603warhead

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271807.14018771.3
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.35924282.0
 
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.