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

231 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
pithead1341959(None) 
pinhead13347071pinhead
pitheads14338141pitheads
pithed124615611pithe_d
pothead133810391pothead
airhead1136992airhead
bighead14126652bighead
cathead1338752cathead
fathead1437862fathead
gilthead1343322gilthead
hothead14349292hothead
kithed144613012kithe_d
pinheads14336242pinheads
pished124817062pishe_d
pitched153512922pitche_d
pitied94017252pitie_d
pitted94319592pitte_d
potheads14298542potheads
printhead1543432printhead
shithead1535522shithead
tithed104115592tithe_d
withed134416232withe_d
acidhead1542793acidhead
ahead96817053__ahead
airheads1246133airheads
airthed11328303airthe_d
althea938193althea_
altheas1038223altheas
bathed125518743bathe_d
behead1239923_behead
bigheads15145653bigheads
billhead1464433billhead
birthed13228593birthe_d
bitched153212923bitche_d
bitted94418483bitte_d
bolthead1445903bolthead
bowhead1636433bowhead
butthead1454513butthead
catheads1438123catheads
cited84421953cit_e_d
cither114616683cithe_r
cithern12489913cithern
cithers124315773cithers
citied94014143citie_d
cohead123811123_cohead
dickhead1944143dickhead
dished114318713dishe_d
ditched143711903ditche_d
dither104417683dithe_r
dithered13189293dithered
dithers114016153dithers
dithery14318943dithery
egghead1343433egghead
either94517423eithe_r
epithet12312463epithe_t
epithets1345763epithets
faithed1437163faithe_d
fatheads1536763fatheads
fished134316313fishe_d
fitted104716663fitte_d
flathead1535803flathead
flinthead1642303flinthead
giltheads1443123giltheads
girthed12266243girthe_d
gitted84015053gitte_d
godhead1334763godhead
head87137173___head
hitched163312253hitche_d
hither124417253hithe_r
hophead16337923hophead
hotheads15318013hotheads
itched123812023_itche_d
ither84617603_ithe_r
jarhead1835173jarhead
jetbead1742983jetbead
jihad1635913ji_h_ad
jughead1933643jughead
kited105120093kit_e_d
kithe125917453kithe__
kithes135016653kithe_s
kitted115114833kitte_d
kythed17407313kythe_d
lathed104718453lathe_d
lethean1037093lethean
lipread1034953lipread
lithe84922013lithe__
lithely1356643lithely
lither94520953lithe_r
lithest10513913lithest
lithia939333lithia_
lithias1038823lithias
lithoed1137833lithoed
lithoid1148773lithoid
masthead1435883masthead
meathead1436793meathead
miched143913393miche_d
mishear1238393mishear
misheard1446253misheard
mislead10419973mislead
misread10339723misread
mither114218563mithe_r
mithers123516733mithers
mitred94414343mitre_d
nailhead1243983nailhead
niched125514063niche_d
nighed113811293nighe_d
outhear10910603outhear
outheard1288543outheard
outlead83311103outlead
outread82811093outread
pashed125923143pashe_d
patched153514623patche_d
pated85237843pat_e_d
pathway1844853pathway
patted94724683patte_d
peched144915343peche_d
petted94121523pette_d
picked154421313picke_d
pieced113912103piece_d
pied75035363pi__e_d
pigged114214153pigge_d
pigheaded1743813pigheaded
pigweed1465093pigweed
piked125623313pi_ke_d
pilea75123953pi_lea_
piled85232993pi_le_d
pilled94222753pille_d
pimped134913483pimpe_d
pinched153812453pinche_d
pineal84817683pi_neal
pined85935323pi_ne_d
pinged104321383pinge_d
pinheaded1644223pinheaded
pinked134819883pinke_d
pinned94818383pinne_d
pinweed1346933pinweed
piped105123163pi_pe_d
pipped104516543pippe_d
piqued1836213pique_d
pisher114317753pishe_r
pishers123815753pishers
pishes114722103pishe_s
pissed94816933pisse_d
pita65436433pit__a_
pitapat1149163pitapat
pitas77427673pit__as
pitaya1186603pitaya_
pitayas1286263pitayas
pitcher143813713pitche_r
pitchers153211483pitchers
pitches143617753pitche_s
pitchman1744013pitchman
pith95432693pith___
pithecoid1753583pithecoid
pithier123010293pithier
pithiest132711443pithiest
pithily1567033pithily
pithing134014053pithing
pithless13117023pithless
piths105817543pith__s
pithy135614463pith__y
pitier84019823pitie_r
pitiers93812653pitiers
pities83828083pitie_s
pitman102412123pit_man
pitmen102510793pitme_n
pitsaw1135613pit_saw
pitta75018693pit_ta_
pittas86014523pit_tas
plead85818463p__lead
plowhead1742803plowhead
poohed123912523poohe_d
postheat13411243postheat
potheen12257893potheen
pother113818853pothe_r
potherb14358683potherb
pothered142311043pothered
pothers123818623pothers
potsherd1434813potsherd
potted94624013potte_d
preheat12413893preheat
printheads1642853printheads
prithee1239933prithe_e
pushed125017463pushe_d
putted94220253putte_d
putzed18409113putze_d
railhead1244183railhead
redhead1257053redhead
rethread1245353rethread
retread849003retread
saphead1357773saphead
shitheads1645043shitheads
sighed113712053sighe_d
sited65130743sit_e_d
sithens1039383sithens
skinhead1643063skinhead
softhead1545003softhead
spathed134013183spathe_d
spited94820443spit_e_d
spitted103912703spitte_d
stead65520273_st_ead
subhead1387693subhead
thread105011093__thread
tithe85319703tithe__
tither94920283tithe_r
tithers104216733tithers
tithes94720213tithe_s
titled73815003title_d
towhead1435223towhead
tread64821703__tread
tythed13457503tythe_d
unthread1244603unthread
untread857413untread
warhead1436603warhead
whitehead1943113whitehead
wished134417513wishe_d
witched163012193witche_d
wited94727143wit_e_d
withal1238933with_al
withe115220233withe__
wither124321353withe_r
withered15169433withered
witherod15156153witherod
withers134417753withers
withes124620843withe_s
withheld1842353withheld
witted104216813witte_d
writhed14389623writhe_d
zither183813083zithe_r
zithern19447023zithern
zithers193911973zithers

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.406440125.6
2DLD Change Limit1340272316.70319995.1
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.20224811.3
 
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.