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

117 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
potheads1429854(None) 
hotheads15318021hotheads
pitheads14338141pitheads
pothead133810391pothead_
boltheads1545122boltheads
bowheads1745372bowheads
catheads1438122catheads
coheads13289232co_heads
fatheads1536762fatheads
godheads1443982godheads
hopheads17276612hopheads
hothead14349292hothead_
pinheads14336242pinheads
pithead13419592pithead_
plowheads1842562plowheads
postheats1447432postheats
potheens13266482potheens
potherbs15387122potherbs
pothers123818622pothe_rs
potsherds1544032potsherds
softheads1644552softheads
towheads1544812towheads
airheads1246133airheads
altheas1038233althea_s
apotheces1644013apotheces
apothegms1742093apothegms
apothems1544223apothe_ms
beheads1338523_beheads
bigheads15145653bigheads
boheas114013213bo_hea_s
bolthead1445903bolthead_
boneheads1545203boneheads
bothers124317753bothe_rs
bowhead1636433bowhead_
buttheads1553903buttheads
cathead1338753cathead_
cohead123811123co_head_
cokeheads1944473cokeheads
coleads102911423co_leads
cowherds1735423cowherds
dopeheads1644143dopeheads
dropheads1643873dropheads
eggheads1442923eggheads
fathead1437863fathead_
flatheads1644873flatheads
foreheads1647033foreheads
giltheads1443123giltheads
goatherds1444203goatherds
godhead1334763godhead_
heads95127113___heads
hogsheads1773673hogsheads
hophead16337923hophead_
hotbeds13315003hotbe_ds
hotheaded1744853hotheaded
jarheads1944793jarheads
jetbeads1842483jetbeads
jugheads2042923jugheads
longheads1444233longheads
mastheads1545243mastheads
meatheads1545963meatheads
mothers123717623mothe_rs
notepads1143343notepads
oreads73915773_o_reads
others93918003_othe_rs
outhears11810393outhears
outleads9278763outleads
outreads9289003outreads
pathways1944273pathways
pinhead13347073pinhead_
pithed124615613pithe_d_
pleads94613953p__leads
plowhead1742803plowhead_
pochards1646853pochards
poohed123912523poohe_d_
poppyheads2051393poppyheads
portends11358963portends
postgrads1344873postgrads
postheat13411243posthea_t
poteens92910883pot_eens
potheen12257893pothe_en
pother113818853pothe__r
potherb14358683pothe_rb
pothered142311043pothered
potholes13312933potholes
pothooks1746053pothooks
pothos114214693poth__os
potshards1544053potshards
potsherd1434813potsherd_
potted94624013potte_d_
potteens10256793potteens
potters94024343potte_rs
potzers184010543potze_rs
preheats1339413preheats
printheads1642853printheads
proteans102811543prot_eans
proteas92015123prot_ea_s
proteids11259953prot_eids
protends113010353prot_ends
protheses1449073protheses
prothesis1449433prothesis
redheads1336173redheads
rethreads1344483rethreads
retreads937823retreads
sapheads1466083sapheads
shitheads1645043shitheads
shortheads1743813shortheads
softhead1545003softhead_
soreheads1346073soreheads
steads74116223_st_eads
subheads1496533subheads
threads11419953__threads
toolheads1343673toolheads
towhead1435223towhead_
treads74817923__treads
unthreads1343633unthreads
untreads936223untreads
warheads1545853warheads

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.500357382.0
2DLD Change Limit1461621177.79618748.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.34221420.6
 
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.