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

280 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
panful117974(None) 
canful11610261canful
manful11610211manful
painful1246411painful
panfuls1237181panfuls
annul55813382_annul
awful1178142_awful
bagful1237212bagful
baneful1237892baneful
canfuls1248422canfuls
cansful1236832cansful
capful1368182capful
carful11610972carful
earful958962earful
gainful1145832gainful
handful14127252handful
hangul1049222hangul
hatful12108742hatful
jarful1646682jarful
lapful1156482lapful
lawful1235492lawful
moanful12105002moanful
pageful1346352pageful
pailful1236102pailful
palmful1445052palmful
panel76023622pan_el
panfry14456412panfry
playful1544652playful
potful1138082potful
sinful938802sinful
tankful1445162tankful
tinful938042tinful
vatful12107082vatful
waeful1238122waeful
afoul8510193_afoul
aidful1057073aidful
aimful1166703aimful
ampul91110853_ampul
anal48037523_an_al
angel65019573_angel
anil46437433_an_il
ankus91410683_ankus
annal56520763_annal
annual64710703_annual
annuli6459053_annuli
annuls64711733_annuls
anus47131113_an_us
anvil82712603_anvil
apneal83411123apneal
armful1167163armful
artful968273artful
babul96317713ba_bul
bagfuls1334753bagfuls
bagsful1344893bagsful
baleful1238003baleful
banal75925993ban_al
bashful1556553bashful
basinful1343233basinful
boatful1236283boatful
boxful18145273boxful
cageful1356483cageful
canal75428043can_al
cancel105316683cancel
cangue91012453cangue
cannel84216403cannel
cannula937443cannula
cantal84122033cantal
cantus85117763cantus
canula8312973can_ula
capfuls1436533capfuls
careful1249113careful
carfuls1249133carfuls
caul65630003ca__ul
consul82312303consul
cupful1356423cupful
dareful1157053dareful
earfuls1036863earfuls
easeful1037293easeful
eyeful1235903eyeful
factful1536373factful
fanciful1643943fanciful
fanfic1436313fanfic
fanfold1485373fanfold
fanum10313443fan_um
farfal123410193farfal
farfel124310433farfel
fateful1397513fateful
fearful1345593fearful
fitful1256333fitful
gangue81310583gangue
hamaul114210873hamaul
handfuls15115753handfuls
handsful1544083handsful
hangup1277303hangup
hansel95214373hansel
harmful1535763harmful
hateful13107683hateful
hatfuls1386023hatfuls
hatsful13106193hatsful
haul75530453ha__ul
headful1445563headful
ireful948713ireful
jarfuls1754773jarfuls
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
kanzu1847593kanzu_
kanzus1944603kanzus
langue71012183langue
langur7109313langur
lapfuls1234503lapfuls
lungful1144013lungful
manfully1645653manfully
mangel94017543mangel
manque17259513manque
mantel84317973mantel
mantua84412023mantua
manual8313463manual
manus75924933man_us
maul64830723ma__ul
mindful1344613mindful
mugful1235403mugful
nonfuel1045733nonfuel
pablum1237503pablum
padauk1335643padauk
padouk1336683padouk
pagefuls1474343pagefuls
pail66141833pa__il
pailfuls1343853pailfuls
pailsful1343263pailsful
painfully1744193painfully
pal56761673pa___l
paleal84716673paleal
pall65039343pa__ll
palmfuls1543473palmfuls
palpal104112053palpal
palpus104210283palpus
pan58466453pan___
panada94113053panada
panama104213353panama
panda85022613pan_da
pandas95521963pandas
pander93725533pander
pandit93820753pandit
pandour10408213pandour
pandura1037143pandura
pandy115021173pan_dy
pane64950293pan__e
paned85437183pan_ed
panels84716523panels
panes76148693pan_es
panfish15229983panfish
pang75336303pan__g
panga85323543pan_ga
pangas99921113pangas
panged104722343panged
pangen94115923pangen
pangs84628673pan_gs
panic93923903pan_ic
panicle11129983panicle
panics103815363panics
panicum1346393panicum
panier84425503panier
panini8314273panini
panino8315683panino
panne76623653pan_ne
panned94123433panned
panner84224763panner
pannes85522853pannes
panoply1434713panoply
pans65855733pan__s
pansy105717973pan_sy
pant66061263pan__t
panted95024823panted
pantie84326473pantie
pantile93918483pantile
panto76129413pan_to
pantos85222743pantos
pantoum1138703pantoum
pantry115014103pantry
pants76536923pan_ts
panty105929303pan_ty
panzer174213233panzer
papal95820673pa_pal
pappus9408373pappus
papula103011123pa_pula
papule102212133pa_pule
parcel103915473parcel
pareu74928743pareu_
pareus85420743pareus
parol74826273pa_rol
parous84024163parous
parral85517543parral
parrel84515983parrel
pascal10812373pascal
pasquil1843923pasquil
passel85117003passel
passus83610293passus
pastel85918713pastel
pastil85018323pastil
patrol83213023patrol
pausal81511963pausal
pawl95123263pa__wl
payout11714653payout
peaceful1545463peaceful
peanut8318183pean_ut
peepul1035783peepul
penal75228373pen_al
pencel103812923pencel
pencil103712973pencil
penial84120893penial
pensil83013333pensil
pentyl1138813pentyl
penult8314653pen_ult
pfui9349793p__fui
picul95015363p_icul
pineal84817693pineal
pinfold1336233pinfold
pinnal84814283pinnal
pinnula934923pinnula
pinnule936003pinnule
pinup9612883pin_up
pipeful1445643pipeful
pitiful1245863pitiful
plaintful1442183plaintful
planula935773plan_ula
plateful1345433plateful
pontil8315463pontil
potfuls1236293potfuls
poutful1236743poutful
pul56138063p___ul
pushful1544493pushful
rackful1645873rackful
ranula6311813ran_ula
rueful948203rueful
sackful1645353sackful
sandal73317283sandal
sannup836563sannup
santol64515243santol
santur6311273santur
saul45836523sa__ul
skinful1444193skinful
snafu8412143snafu_
snafus936743snafus
sobful1136333sobful
songful1145173songful
spadeful1443963spadeful
spancel1147363spancel
spaniel948923spaniel
spansule1043633spansule
spoonful1343753spoonful
swayful1643003swayful
synfuel1342433synfuel
tactful1236163tactful
tankfuls1543803tankfuls
tearful1046033tearful
teenful1045563teenful
thankful1843253thankful
tinfuls1036593tinfuls
topful1136543topful
trainful1145193trainful
trayful1344583trayful
tubful1136683tubful
tuneful1046123tuneful
unfurl937953_unfurl
unmanful1343433unmanful
unpainful1452193unpainful
useful947013useful
vandal103713833vandal
vatfuls1384853vatfuls
vauntful1442473vauntful
wailful1344953wailful
wakeful1735613wakeful
wameful1535673wameful
wangun1037113wangun
waul76927313wa__ul
wilful1235963wilful
woeful1236363woeful
woful1158173_woful
yanqui1843383yanqui

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 Filter1786911127160.500357382.0
2DLD Change Limit1127162807.72014600.5
3Display Results2802800.1861505.4
 (SQL Overall)1786912808.40621257.6
 
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.