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

221 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
saphead135777(None) 
sapheads1466081sapheads
ahead96817052_a_head
cathead1338752cathead
fathead1437862fathead
hophead16337922hophead
jarhead1835172jarhead
sapheaded1644182sapheaded
saphena1235862saphena
saphenae1344852saphenae
saphenas1345712saphenas
sapped114422012sappe_d
sashed105622942sashe_d
spread9312532s_pread
subhead1387692subhead
warhead1436602warhead
aahed917816443_aahe_d
ached119227833_ache_d
ahed89536253_a_he_d
airhead1136993airhead
apeak115513453_ap_eak
aped78538153_ap_e_d
aphid115515393_aph_id
apnea73413413_apnea_
apneal83411123_apneal
apneas83211383_apneas
appeal103911613_appeal
appear10379343_appear
append1138273_append
ashed97829773_ashe_d
bached145519893bache_d
baldhead1544273baldhead
barehead1446603barehead
bashed126225703bashe_d
bathed125518743bathe_d
behead1239923_behead
bighead14126653bighead
bowhead1636433bowhead
cached145419203cache_d
caped104931803cap_e_d
capped134721853cappe_d
cashed125124353cashe_d
catheads1438123catheads
cepheid1545433cepheid
cohead123811123_cohead
dapped124516763dappe_d
dashed115920563dashe_d
deadhead1444433deadhead
dopehead1544073dopehead
drophead1544613drophead
egghead1343433egghead
fashed136720253fashe_d
fatheads1536763fatheads
flathead1535803flathead
gaped96123533gap_e_d
gapped124217123gappe_d
gashed116321973gashe_d
gearhead1344433gearhead
godhead1334763godhead
graphed1498473graphe_d
happed144820103happe_d
hardhead1645883hardhead
hashed136021943hashe_d
hashhead1443263hashhead
head87137173___head
hopheads17276603hopheads
hothead14349293hothead
implead12315823implead
japed156217633jap_e_d
jarheads1944793jarheads
jughead1933643jughead
lapped114320033lappe_d
lapsed94712583lapse_d
lashed105625213lashe_d
lathed104718453lathe_d
lipread1034953lipread
mapped134015883mappe_d
mashed125325043mashe_d
masthead1435883masthead
meathead1436793meathead
nailhead1243983nailhead
napped114218163nappe_d
paphian1437453paphian
pashed125923143pashe_d
pinhead13347073pinhead
pithead13419593pithead
plead85818463__plead
pothead133810393pothead
railhead1244183railhead
ralphed1334363ralphe_d
raped85334623rap_e_d
raphae114311733raph_ae
raphe104916423raphe__
raphes115117453raphe_s
raphia113511263raphia_
raphias123511083raphias
rapped114122683rappe_d
redhead1257053redhead
replead10399003replead
sabbed114518083sabbe_d
sabed86526813sa_be_d
sabred95916533sabre_d
sachem134012223sache_m
sachems14348903sachems
sachet114725773sache_t
sacheted14127833sacheted
sachets123914103sachets
sacked135525213sacke_d
sacred94917103sacre_d
sadhe94815133sadhe__
sadhes104715373sadhe_s
sagged94120013sagge_d
sailed74327763saile_d
sained75424243saine_d
salad65321833sa__lad
salted74121203salte_d
salved103916423salve_d
sambaed1238303sambaed
sampled123410793sample_d
sanded84920613sande_d
saned65636273sa_ne_d
sapid84720933sap__id
sapiens9310173sapiens
sapient9415333sapient
sapless93313443sapless
sapota8310213sapota_
sapotas939613sapotas
sapper103822353sappe_r
sappers113518903sappers
sapwood1366913sapwood
sashay1238363sash_ay
sashes94728483sashe_s
sassed76116173sasse_d
sated66238533sa_te_d
sauced93913303sauce_d
saunaed836703saunaed
sauted74119603saute_d
sauteed8349613sauteed
saved95127113sa_ve_d
sawed95628403sa_we_d
sayed96127143sa_ye_d
scaped115519553scap_e_d
scaphoid1646053scaphoid
scarehead1543803scarehead
scarphed1635443scarphe_d
scathed134012643scathe_d
scrapheap1892003scrapheap
shad86230913s__h_ad
shaped125020103shap_e_d
shea76031573s__hea_
sheaf115424123s__heaf
sheal84927703s__heal
shear85424833s__hear
sheas86331793s__heas
shed86536153s__he_d
sheephead1863893sheephead
shend94719973s__hend
shepherd1744373shepherd
sherd96321153s__herd
shithead1535523shithead
sighed113712053sighe_d
siped84927683sip_e_d
sipped113720633sippe_d
skinhead1643063skinhead
slapped123511843slappe_d
slashed114114853slashe_d
smashed133711223smashe_d
snakehead1742773snakehead
snapped124611203snappe_d
snapweed1443453snapweed
soaped95817973soap_e_d
softhead1545003softhead
sopped114819903soppe_d
sorehead1246973sorehead
spaced114517253space_d
spaded103816753spade_d
spaed85522273s_pae_d
spahee11313443spahe_e
spahees1238263spahees
spared95427493spare_d
spathed134013183spathe_d
spayed124213613spaye_d
speak114618673s_p_eak
spean74620513s_p_ean
spear75821063s_p_ear
spearhead1542983spearhead
sped76031493s_p_e_d
speed85526623s_p_eed
spend85619333s_p_end
sphene113412403s_phene
spheral1238423s_pheral
sphere113313663s_phere
sphered133512313s_phered
sphery14318883s_phery
spied85427713s_pie_d
spreads1039763s_preads
spued84918473s_pue_d
stairhead1343323stairhead
stapled103613703staple_d
stashed113812493stashe_d
stead65520273s__tead
subheads1496533subheads
sughed113610203sughe_d
supped114415703suppe_d
swanherd1533483swanherd
swapped15429143swappe_d
swashed144311363swashe_d
swathed144611933swathe_d
sypher14317083syphe_r
syphered1755013syphered
syphers15317273syphers
taped85327423tap_e_d
tapped113820053tappe_d
towhead1435223towhead
upheap13105213_upheap
upheld12115563_upheld
wapped144416473wappe_d
warheads1545853warheads
washed135521503washe_d
yapped144415143yappe_d
zapped204213523zappe_d

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 Limit1340272217.00019146.7
3Display Results2212210.0762907.9
 (SQL Overall)1786912217.23224708.4
 
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.